[GENERAL] My DataBase can't accept conntecion

2011-01-12 Thread zab08
we have e test db server, we use jdbc to contect. but after a whie, The test db server can not accept connect. useps aux | grep postgrescommand : postgres 16904 0.0 0.0 46036 3948 ?S17:03 0:00 /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data postgres 16906 0.0 0.0 4614

Re: [GENERAL] Postgres in FIPS

2011-01-12 Thread M Sabin
Yes, we require SSL connections, because we have multiple clients that access the database external from the server where the database resides. Michael On Tue, Jan 11, 2011 at 10:36 PM, Kenneth Buckler wrote: > Something to think about heredoes your database actually require > encryption? Or

Re: [GENERAL] My DataBase can't accept conntecion

2011-01-12 Thread Robert Gravsjö
On 2011-01-12 13.13, zab08 wrote: we have e test db server, we use jdbc to contect. but after a whie, The test db server can not accept connect. useps aux | grep postgrescommand : postgres 16904 0.0 0.0 46036 3948 ?S17:03 0:00 /usr/local/pgsql/bin/postgres -D /usr/local/pgs

Re: [GENERAL] My DataBase can't accept conntecion

2011-01-12 Thread Bill Moran
In response to zab08 : > we have e test db server, we use jdbc to contect. > but after a whie, The test db server can not accept connect. > > > useps aux | grep postgrescommand : > postgres 16904 0.0 0.0 46036 3948 ?S17:03 0:00 > /usr/local/pgsql/bin/postgres -D /usr/local/pgs

Re: [GENERAL] Question about concurrent synchronous and asynchronous commits

2011-01-12 Thread Vick Khera
On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken wrote: > If I commit asynchronously and then follow that with a synchronous commit, > does that flush the asynchronous commit as well? I'm pretty sure it does, because it has to flush the write-ahead log to disk, and there's only one. You can think of

Re: [GENERAL] My DataBase can't accept conntecion

2011-01-12 Thread zab08
At 2011-01-12 23:22:40，"Bill Moran" wrote: >In response to zab08 : > >> we have e test db server, we use jdbc to contect. >> but after a whie, The test db server can not accept connect. >> >> >> useps aux | grep postgrescommand : >> postgres 16904 0.0 0.0 46036 3948 ?S17:03

[GENERAL] Large object performance

2011-01-12 Thread Bosco Rama
Hi folks, I've been using large objects in 8.4.x for some time now and have noticed that some operations on large objects appear to take an inordinate amount of time. For example, the \lo_list command in psql seems slow for what it does (many seconds before first printed line with only a few thou

Re: [GENERAL] Large object performance

2011-01-12 Thread Tom Lane
Bosco Rama writes: > Hi folks, > I've been using large objects in 8.4.x for some time now and have noticed that > some operations on large objects appear to take an inordinate amount of time. > For example, the \lo_list command in psql seems slow for what it does (many > seconds before first prin

Re: [GENERAL] Large object performance

2011-01-12 Thread Wohld, Adam
unsubscribe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] sprintf

2011-01-12 Thread tbazadaykin
I need something like that SELECT sprintf('String with pattens: %d, %s',13,'abc'); and return: 'String with pattens: 13, abc'; Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] sprintf

2011-01-12 Thread Pavel Stehule
Hello, 2011/1/13 tbazadaykin : > I need something like that > > SELECT sprintf('String with pattens: %d, %s',13,'abc'); > function sprintf is available from pltoolbox library http://pgfoundry.org/frs/?group_id=1000457 Regards Pavel Stehule > and return: > > 'String with pattens: 13, abc'; >