Jack Orenstein wrote:
I'm using postgresql 8.3.7. Under what conditions does a JDBC prepared
statement
result in a server-side prepared statement?
http://jdbc.postgresql.org/development/privateapi/org/postgresql/PGStatement.html#setPrepareThreshold(int)
The default is 5, as far as I
Whit Armstrong wrote:
I needed to write a product aggregate function, and just happened to
find this example in the nodes to the 8.0 manual:
[...]
but that example looks pretty different than the ones found in the 8.3
manual (avg for instance):
[...]
Are there any experts out there
On Wed, Jun 24, 2009 at 10:07 PM, Dragan
Sahpaskidragan.sahpas...@gmail.com wrote:
Ok the same thing happened with the 8.3.7 installer after a few hours - not
right away.
I uninstalled the 8.4, and there are no libuuid files in /opt/8.3/lib/.
No, uuid-ossp isn't included in the 8.3 installer,
l...@crysberg.dk wrote:
I'm using PostgreSQL in a server project that uses many
forks and many threads in each forked process.
Almost everytime I do a pthread_cancel() I get a SIGSEGV.
I have then linked the libmudflapth into my program to catch
the problem sooner and now that
Hi,
How can I add a character as space symbol for the full text search indexes?
I'm adding firewall syslog lines in a database (8.3.7), and have a GIN
index on the message field. I'd like the slash considered a space symbol,
so i can search for IPnumbers in test like
world/123.456.192.46(0) -
On Thu, 25 Jun 2009, Henk van Lingen wrote:
Hi,
How can I add a character as space symbol for the full text search indexes?
I'm adding firewall syslog lines in a database (8.3.7), and have a GIN
index on the message field. I'd like the slash considered a space symbol,
so i can search for
On 2009-06-23, Mike Christensen m...@kitchenpc.com wrote:
Does anyone actually have that (any node
can go down and the others still replicate amongst themselves?)
you are describing usenet. (it was not designed for relational database
replication but it does have that feature)
--
Sent via
On Thu, Jun 25, 2009 at 01:05:41PM +0400, Oleg Bartunov wrote:
How can I add a character as space symbol for the full text search indexes?
I'm adding firewall syslog lines in a database (8.3.7), and have a GIN
index on the message field. I'd like the slash considered a space symbol,
so i can
On Thu, Jun 25, 2009 at 2:59 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jack Orenstein wrote:
I'm using postgresql 8.3.7. Under what conditions does a JDBC prepared
statement
result in a server-side prepared statement?
Hi CMJ,
If you are using WebNMS framework with hibernate, can you check if you have
done this:
*ConfigReader configReader = ConfigReader.getInstance();
configReader.modifyHbmToDdl(true);
*
Thanks,
Saurabh
On Wed, Jun 24, 2009 at 6:06 PM, CM J postgres.new...@gmail.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I've got a somewhat 'hairy' problem in my hands...
One of my servers is still Fedora Core (cough) (cough) 6 :]
It's running Postgresql 8.2.4
I want it to serve as a last resort, end of the spectrum, backup/slave
for another server running
In response to Pedro Doria Meunier pdo...@netmadeira.com:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I've got a somewhat 'hairy' problem in my hands...
One of my servers is still Fedora Core (cough) (cough) 6 :]
It's running Postgresql 8.2.4
I want it to serve as a last
On Thu, Jun 25, 2009 at 10:04 PM, Pedro Doria Meunier pdo...@netmadeira.com
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I've got a somewhat 'hairy' problem in my hands...
One of my servers is still Fedora Core (cough) (cough) 6 :]
It's running Postgresql 8.2.4
I want
Hi,
i would like to execute the following SQL command into a function based on
some IF, END IF tests before.
how can i do that ?
here is my SQL command:
create table sw.tmp_import
(
id serial NOT NULL,
software VARCHAR(1024),
barcode VARCHAR(10),
username VARCHAR(1024),
area
On Thu, Jun 25, 2009 at 1:28 PM, Guy Flahertynaosh...@gmail.com wrote:
One of my servers is still Fedora Core (cough) (cough) 6 :]
It's running Postgresql 8.2.4
I want it to serve as a last resort, end of the spectrum, backup/slave
for another server running Postgresql 8.2.9 via Slony-I.
On Wed, Jun 24, 2009 at 11:45 PM, Scott
Meadscott.li...@enterprisedb.com wrote:
If you're asking Does the database have the ability to verify that
whatever is in a block is what was put into that block, then Oracle has
block check-summing (I'm not sure if this got into PG 8.4 or not...)
It
On Thu, Jun 25, 2009 at 02:53:59PM +0200, Alain Roger wrote:
i would like to execute the following SQL command into a function based on
some IF, END IF tests before.
how can i do that ?
1. you can use execute in pl/pgsql.
2. if your ifs are basically testing if the table exists - you might
This is what i did at the beginning and it did not work. But now i've just
discovered that my create table command was wrong...so it's ok. :-)
thx.
A.
On Thu, Jun 25, 2009 at 3:01 PM, Frank Heikens frankygoesto...@mac.comwrote:
A very simple and incomplete example:
CREATE OR REPLACE FUNCTION
I'm confused now because if i try my SQL command alone it works without any
problem, but in the following pglSQL code, it does not :-(
IF (outResult = 1) THEN
return true;
ELSE
EXECUTE 'create table sw.tmp_import (id serial NOT NULL CONSTRAINT id_key
PRIMARY KEY, software VARCHAR(1024),
On Thursday 25 June 2009 6:29:10 am Alain Roger wrote:
I'm confused now because if i try my SQL command alone it works without any
problem, but in the following pglSQL code, it does not :-(
What is the error?
IF (outResult = 1) THEN
return true;
ELSE
EXECUTE 'create table
I started an online backup of postgres, tar’d my data folder, copy to usb
drive in production
and restored it into my RC environment. Have I missed
something important?
Online
Backup
psql
checkpoint;
SELECT
pg_switch_xlog();
SELECT
Henk van Lingen h.g.k.vanlin...@uu.nl writes:
I understand the ts_search parser is not configurable?
You can substitute your own parser, but the built-in one doesn't have
any provisions for fine-grained configuration.
regards, tom lane
--
Sent via pgsql-general mailing
Hi,
Runnning: initdb -E LATIN1 -D .
Error: encoding mismatch
Used to run fine on 8.2.4 on the same Windows platform.
OUTPUT
===
The database cluster will be initialized with locale English_United States.1252.
initdb: encoding mismatch
The encoding you selected (LATIN1) and the
I am not .2 instance that won't come up after shutdown
But cannot add more posts.
Thanks a lot
Danny
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Where can i find plpython.so in the Fedora 11 i586 rpm packages? The
postgresql-python does not have it:
$ rpm -q --filesbypkg postgresql-python | grep plpython
$
http://download.fedora.redhat.com/pub/fedora/linux/releases/11/Fedora/i386/os/Packages/postgresql-python-8.3.7-1.fc11.i586.rpm
There
Good morning.
On occasion I'll perform a full vacuum on a database but will still
receive a suggestion to vacuum an individual table immediately after.
Does the full database vacuum not handle each individual table?
Thanks,
Matthew Hartman
Programmer/Analyst
Information Management, ICP
On Thursday 25 June 2009, Chris Barnes compuguruchrisbar...@hotmail.com
wrote:
I started an online backup of postgres, tar’d my data folder, copy to
usb drive in production
and restored it into my RC environment. Have I missed
something important?
You need the transaction logs archived
2009/6/25 Clodoaldo Pinto Neto clodoaldo.pinto.n...@gmail.com:
Where can i find plpython.so in the Fedora 11 i586 rpm packages? The
postgresql-python does not have it:
$ rpm -q --filesbypkg postgresql-python | grep plpython
$
On Wed, Jun 24, 2009 at 11:03:07PM -0700, mobiledream...@gmail.com wrote:
GOals are to scale our game for 1 simultaneous connection to db
right now db crashing at 500 or 1000 sim connections
Consider using pgbouncer to multiplex your database connections.
If that doesn't work, consider
Teodor,
I ran across a commit message that shows multibyte encoding support in
8.4 and my testing shows that to be the case as well. Is there a
back patch for 8.2? My own quick attempt at creating one didn't work
so well and before I start spending some major time trying I thought
On Thu, Jun 25, 2009 at 3:40 PM, Hartman,
Matthewmatthew.hart...@krcc.on.ca wrote:
On occasion I’ll perform a full vacuum on a database but will still receive
a suggestion to vacuum an individual table immediately after. Does the full
database vacuum not handle each individual table?
What's
Alain Roger escribió:
IF (outResult = 1) THEN
return true;
ELSE
EXECUTE 'create table sw.tmp_import (id serial NOT NULL CONSTRAINT id_key
PRIMARY KEY, software VARCHAR(1024), barcode VARCHAR(10), username
VARCHAR(1024), area VARCHAR(512), locality VARCHAR(512)) WITH
(OIDS=FALSE);';
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
First of all, thank you all who have replied so far :)
The FC8 server has been upgraded to 8.2.13 with minor glitches :)
I'm one step shy of upgrading it to 8.3 :P
Btw: I'm using the http://yum.pgsqlrpms.org/ repository as the source
for the upgrade.
A very simple and incomplete example:
CREATE OR REPLACE FUNCTION new_table(int) returns bool AS
$$
BEGIN
IF $1 = 1 THEN
EXECUTE 'CREATE TABLE x()';
ELSIF $1 = 2 THEN
EXECUTE 'CREATE TABLE y()';
ELSE
EXECUTE 'CREATE TABLE
Sorry if posting twice, wasn't part of general when sent and didn't see it
received by group.
I started an online backup of postgres, tar'd my data folder, copy to usb
drive in production
and restored it into my RC environment. Have I missed something important?
Online Backup
psql
I started an online backup of postgres, tar'd my data folder, copy to usb
drive in production
and restored it into my RC environment. Have I missed something important?
When starting the database I receive many errors that look like the backup
was corrupted.
2009-06-23 08:29:15
miao= \d items
Table public.items
Column | Type | Modifiers
+--+
id | integer | not null default
nextval('items_id_seq'::regclass)
tags
Jim thanks
Can you please show how to setup partitining in gridsql and pgpool 2
thanks a lot
On Mon, Jun 15, 2009 at 10:28 AM, Jim Mlodgenski jimm...@gmail.com wrote:
what is a good way to horizontal shard in postgresql
1. pgpool 2
2. gridsql
which is a better way to use sharding
Both
GOals are to scale our game for 1 simultaneous connection to db
right now db crashing at 500 or 1000 sim connections
On Mon, Jun 15, 2009 at 8:07 AM, David Fetter da...@fetter.org wrote:
On Mon, Jun 15, 2009 at 12:32:15AM -0700, mobiledream...@gmail.com wrote:
Hey guys
what is a good
Windows XP, PostgreSQL 8.3.5, using pgAdmin III 1.8.4. It's the typical
Running vacuum on this table is recommended dialog box.
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549- x4294
-Original Message-
From: Grzegorz Jaśkiewicz
I know questions like this have been asked before, but I hadn't seen one
quite from the same perspective (although I'm sure it's out there
somewhere).
We have a database which has one long involved procedure early in the
morning that updates all sorts of things, moves data around, deletes some
Abraham, Danny wrote:
Hi,
Runnning: initdb -E LATIN1 -D .
Error: encoding mismatch
Right. Try using Win1252 instead of Latin1:
initdb -E win1252 ...
Or just leave -E out entirely, since it will be picked up by default
from the locale setting anyway.
--
Alvaro Herrera
2009/6/25 Hartman, Matthew matthew.hart...@krcc.on.ca:
Windows XP, PostgreSQL 8.3.5, using pgAdmin III 1.8.4. It's the typical
Running vacuum on this table is recommended dialog box.
Well, it really has nothing to do with postgresql it self. Either it
is a bug or property of PgAdmin, but I
2009/6/25 Grzegorz Jaśkiewicz gryz...@gmail.com:
2009/6/25 Hartman, Matthew matthew.hart...@krcc.on.ca:
Windows XP, PostgreSQL 8.3.5, using pgAdmin III 1.8.4. It's the typical
Running vacuum on this table is recommended dialog box.
Well, it really has nothing to do with postgresql it self.
Chris Spotts wrote:
The transaction itself works flawlessly, but every once and awhile the data
the it uploads from comes in flawed and we have to find a way to reset it.
This reset involves restoring a backup that was taken right before the proc
started. If we had the xid of the long running
On Thu, Jun 25, 2009 at 10:40 AM, Hartman,
Matthewmatthew.hart...@krcc.on.ca wrote:
Good morning.
On occasion I’ll perform a full vacuum on a database but will still receive
a suggestion to vacuum an individual table immediately after. Does the full
database vacuum not handle each
On Thursday 25 June 2009, Chris Spotts rfu...@gmail.com wrote:
The transaction itself works flawlessly, but every once and awhile the
data the it uploads from comes in flawed and we have to find a way to
reset it. This reset involves restoring a backup that was taken right
before the proc
But it'll do so immediately after I run a full vacuum on the entire database?
Nothing has changed. This is a development box.
You know, I bet it doesn't refresh the view of the database after having run
the maintenance script..
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Dave Page dp...@pgadmin.org writes:
pgAdmin will advise vacuuming a table if there is a significant
discrepancy between the number of rows in the table and the value in
pg_class.reltuples. i forget the exact algorithm off-hand, but it
takes the size of the table into account, and is looking
I do have autovacuum on (as of yesterday). This was discovered when I
ran vacuum on a whim.
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549- x4294
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent:
I added datestyle = 'SQL,MDY' to the postgres.conf (restarted the server).
But it does not appear to work with any setting. Is this a bug? Did I do
it wrong?
openSUSE 11.0 postgres 8.3.7
--
John Fabiani
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Thu, Jun 25, 2009 at 12:03 AM, mobiledream...@gmail.com wrote:
GOals are to scale our game for 1 simultaneous connection to db
right now db crashing at 500 or 1000 sim connections
Definitely look into pooling. I've got a pretty hefty database server
(16 15k5 drives, HW RAID, 32Gig RAM
On Thu, Jun 25, 2009 at 8:40 AM, Hartman,
Matthewmatthew.hart...@krcc.on.ca wrote:
Good morning.
On occasion I’ll perform a full vacuum on a database but will still receive
a suggestion to vacuum an individual table immediately after. Does the full
database vacuum not handle each individual
I will create several databases on PostGreSQL. All the databases have the
same structure: same number of table/index.
I have two choices:
1. For each database, I create a new tablespace and create a new database in
the tablespace.
2. I only create one tablespace. Create all the databases on the
In response to Jack W dbdevelop2...@gmail.com:
I will create several databases on PostGreSQL. All the databases have the
same structure: same number of table/index.
I have two choices:
1. For each database, I create a new tablespace and create a new database in
the tablespace.
2. I only
Hello,
I'd like to understand the PostgreSQL internals in backup mode.
When I understood it correctly pg_start_backup() make a checkpoint and
stops writing to the data/ directory except the WAL.
All new transaction go into WAL which is also logical. But how is data
consistency done when the
In response to Jack W dbdevelop2...@gmail.com:
On Thu, Jun 25, 2009 at 11:37 AM, Bill Moran wmo...@potentialtech.comwrote:
In response to Jack W dbdevelop2...@gmail.com:
I will create several databases on PostGreSQL. All the databases have the
same structure: same number of
Gerhard Wiesinger wrote:
Hello,
I'd like to understand the PostgreSQL internals in backup mode.
When I understood it correctly pg_start_backup() make a checkpoint and
stops writing to the data/ directory except the WAL.
All new transaction go into WAL which is also logical. But how is data
On Thu, Jun 25, 2009 at 12:10 PM, Bill Moran wmo...@potentialtech.comwrote:
In response to Jack W dbdevelop2...@gmail.com:
On Thu, Jun 25, 2009 at 11:37 AM, Bill Moran wmo...@potentialtech.com
wrote:
In response to Jack W dbdevelop2...@gmail.com:
I will create several databases
Folks,
For any PostgresQL users who live in San Jose, or are planning to attend
OSCON, we have a full day of PostgreSQL talks on Sunday July 19th. Full
details, including free registration information are here:
http://wiki.postgresql.org/wiki/PgDaySanJose2009
--Josh Berkus
--
Sent via
Chris Spotts escribió:
The transaction itself works flawlessly, but every once and awhile the data
the it uploads from comes in flawed and we have to find a way to reset it.
This reset involves restoring a backup that was taken right before the proc
started. If we had the xid of the long
On Thu, Jun 25, 2009 at 9:40 AM, Chris Spottsrfu...@gmail.com wrote:
We have a database which has one long involved procedure early in the
morning that updates all sorts of things, moves data around, deletes some
stuff, alters some DDL - you name it, it does it. The rest of the day, the
The transaction itself works flawlessly, but every once and awhile the data
the it uploads from comes in flawed and we have to find a way to reset it.
If you can automate the tests for the flaws you can do the whole
transaction itself as one big transaction in Postgres. Even DDL can be
done in
preprocess text, for example, using replace(), regexp_replace() functions
Oke, you mean at the time the insert in de db is done, i suppose.
However, I'm using the new syslog-ng 3 feature which does the
insert directly. So I have to change the syslogd for that.
I understand the ts_search
Assuming that the data is mostly created from whole cloth each
morning, it might do to have two dbs, and rename one to replace the
other when you're ready. Gives you 20 or so hours to discover a screw
up and still have the backup db before you toss it away to build the
next day
For this
On Thu, 2009-06-25 at 21:59 +0100, Greg Stark wrote:
The transaction itself works flawlessly, but every once and awhile the data
the it uploads from comes in flawed and we have to find a way to reset it.
If you can automate the tests for the flaws you can do the whole
transaction itself as
I want to be able to change the behavior of some functions based on
custom runtime variables.
I added the following lines to my postgresql.conf file:
custom_variable_classes = 'foo'
foo.name = '1s'
Now if I do show foo.name I get '1s'
But it does not show up in show all or in pg_settings.
I
Scott Bailey arta...@comcast.net writes:
I added the following lines to my postgresql.conf file:
custom_variable_classes = 'foo'
foo.name = '1s'
Now if I do show foo.name I get '1s'
But it does not show up in show all or in pg_settings.
No, it doesn't. It should still work in set/show
Hello,
OK, what's then the difference doing a pg_start_backup() or just
doing the backup?
Isn't that a problem that the datablock are very inconsistent, even so
inconsistent that they are corrupt:
E.g. A part of a datablock is written when e.g. the file is tarred. =
Datablock on backup is
Hi,
The problem turned out to be not with postgres but my JDBC connection
code.
Thanks !
On Thu, Jun 25, 2009 at 5:25 PM, Saurabh Dave saurabhd...@gmail.com wrote:
Hi CMJ,
If you are using WebNMS framework with hibernate, can you check if you have
done this:
*
Gerhard Wiesinger wrote:
Hello,
OK, what's then the difference doing a pg_start_backup() or just doing
the backup?
pg_start_backup() forces a checkpoint (and logs a label for your backup
too).
Isn't that a problem that the datablock are very inconsistent, even so
inconsistent that they
71 matches
Mail list logo