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 remem
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
On Wed, Jun 24, 2009 at 10:07 PM, Dragan
Sahpaski 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, so the offending
librar
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 IPnu
On 2009-06-23, Mike Christensen 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 pgsql-general mai
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,
On Thu, Jun 25, 2009 at 2:59 AM, Albe Laurenz wrote:
> 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.htm
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 wrote:
> Hi ,
>
> I
-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 Po
In response to Pedro Doria Meunier :
> -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
On Thu, Jun 25, 2009 at 10:04 PM, Pedro Doria Meunier 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 it to serve
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 VARCHAR(512)
On Thu, Jun 25, 2009 at 1:28 PM, Guy Flaherty 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.
Before doing anyt
On Wed, Jun 24, 2009 at 11:45 PM, Scott
Mead 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 didn't, due to technic
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
w
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 wrote:
> A very simple and incomplete example:
>
> CREATE OR REPLACE FUNCTION new_table(int) retur
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
pg_start_backup('postres_full_
Henk van Lingen 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 list (pgsql-general@
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 enc
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
Ki
On Thursday 25 June 2009, Chris Barnes
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 during and immediately after t
2009/6/25 Clodoaldo Pinto Neto :
> 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/po
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 hi
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
I'd
On Thu, Jun 25, 2009 at 3:40 PM, Hartman,
Matthew 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 the exact message, what OS
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
> > (OI
-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 z()'
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
checkpoint;
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 EDT:@:7614E
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 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 are
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 wrote:
> On Mon, Jun 15, 2009 at 12:32:15AM -0700, mobiledream...@gmail.com wrote:
> > Hey guys
> > what is a good way to horizon
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 :
> 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 don't know.
Either someone
2009/6/25 Grzegorz Jaśkiewicz :
> 2009/6/25 Hartman, Matthew :
>> 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
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,
Matthew 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 table?
As of 8.3,
On Thursday 25 June 2009, "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 w
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
King
Dave Page 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 for a %age
> dif
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: Thursday
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, 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 and 8 cores) and I would
On Thu, Jun 25, 2009 at 8:40 AM, Hartman,
Matthew 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 table?
Wait, is this a
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 sam
In response to Jack W :
> 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
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 th
In response to Jack W :
> On Thu, Jun 25, 2009 at 11:37 AM, Bill Moran wrote:
>
> > In response to Jack W :
> >
> > > 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
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 wrote:
> In response to Jack W :
>
> > On Thu, Jun 25, 2009 at 11:37 AM, Bill Moran >wrote:
> >
> > > In response to Jack W :
> > >
> > > > I will create several databases on PostGreSQL. All the databases have
> the
> > > > same structure: same number
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 pgsq
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 Spotts 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
> database is re
>> 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
> > 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_se
>
> 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 t
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 i
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 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 though.
> Also,
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 wrote:
> Hi CMJ,
>
> If you are using WebNMS framework with hibernate, can you check if you have
> done this:
>
> *ConfigReader configReader
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 ar
I copied the sample config file to postgresql workign directory before
trying to start postgresql:
# pwd
/usr/local/share/postgresql
twp1:postgresql # cp postgresql.conf.sample ../../pgsql/data/postgresql.conf
On Fri, Jun 26, 2009 at 4:04 PM, Sam Wun wrote:
> Hi,
>
> I had been running postgresql
Hi,
I had been running postgresql 8.3.7 in freebsd for some time, but
after I changed its postgresql.conf file, it can't start any more
eventhoguh I changed the config back to its original file.
Anything wrong?
Here is the errros:
Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL: could not crea
73 matches
Mail list logo
