Re: [ADMIN] Unable To Establish Connections

2011-05-17 Thread Sam Stearns
Thanks, Tim. I've turned up logging some more. On Wed, May 18, 2011 at 8:38 AM, Tim wrote: > First google hit said this: > > "It seems (not sure) to occur when user retypes password fast. > Maybe in this case ODBC driver gets old connection somehow from driver > manager." > > also > "It looks to

Re: [ADMIN] Unable To Establish Connections

2011-05-17 Thread Tim
First google hit said this: "It seems (not sure) to occur when user retypes password fast. Maybe in this case ODBC driver gets old connection somehow from driver manager." also "It looks to me like the ODBC driver is failing to follow the protocol. It shouldn't respond with an 'X' if it doesn't h

Re: [ADMIN] Unable To Establish Connections

2011-05-17 Thread Sam Stearns
Anyone have any ideas on this? We're an ISP. I was thinking of the possibility of a hack attempt. On Tue, May 17, 2011 at 6:52 PM, Sam Stearns wrote: > Howdy, > > Environment: > > Postgres 8.2.3 > Solaris 10 > > We were unable to make a remote postgres connection for ~2 hours this > afternoon.

[ADMIN] postgres on CVFS / StorNext filesystem

2011-05-17 Thread Maria L. Wilson
Anybody have any experience or issues running postgres (version8.4) on a CVFS filesystem? thanks much Maria Wilson NASA/Langley Research Center Hampton, Virginia 23681 m.l.wil...@nasa.gov -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription

Re: [ADMIN] question about installation PostgreSQL

2011-05-17 Thread Tim
I would use task manager to check if PostgreSQL is actually running. If it is I would disable the firewall, if it's not I would check if the data directory is empty, and look at the PostgreSQL and windows logs. It's also odd that you see [host "???"], I would expect it to be [host "127.0.0.1"] mayb

[ADMIN] question about installation PostgreSQL

2011-05-17 Thread truongxuan quang
Dear list I face with some problem in installation PostgreSQL 8.3 on winXP , long time before I used PostgreSQL and PostGIS for managing shape file data. Last week I tried to install PostgreSQL 8.4, after that I removed PostgreSQL 8.3 (I only uninstalled inside windows control panel/add and the

[ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum

2011-05-17 Thread Florian Helmberger
Hi. I'm running a production database with PostgreSQL 9.0.3 (64-bit) on Debian 5.0.4 and have an issue with a TOAST table and far to frequent autovacuum runs. I think I've pinned the problem down to the values pg_class holds for the affected TOAST table: relpages | 433596 reltuples | 1868

[ADMIN] Unable To Establish Connections

2011-05-17 Thread Sam Stearns
Howdy, Environment: Postgres 8.2.3 Solaris 10 We were unable to make a remote postgres connection for ~2 hours this afternoon. Receiving the following message in the postgres log every 30 seconds: LOG: expected password response, got message type 88 Connection limit is 300. 17 active connec