Yvon Thoraval wrote: >> You may want to set log_statement='all' in postgresql.conf > i did this change , restart PostgreSQL and test again, with the same error, however postgres log > didn't report any error, as far as i understand the log : > > 2012-09-14 18:43:14 CEST LOG: received fast shutdown request > 2012-09-14 18:43:14 CEST LOG: aborting any active transactions > 2012-09-14 18:43:14 CEST LOG: autovacuum launcher shutting down > 2012-09-14 18:43:14 CEST LOG: shutting down > 2012-09-14 18:43:14 CEST LOG: database system is shut down > 2012-09-14 18:43:17 CEST LOG: database system was shut down at 2012-09-14 18:43:14 CEST > 2012-09-14 18:43:17 CEST LOG: incomplete startup packet > 2012-09-14 18:43:17 CEST LOG: database system is ready to accept connections > 2012-09-14 18:43:17 CEST LOG: autovacuum launcher started Well, "received fast shutdown request" would explain what is going on. The server shuts down, and all active connections are terminated, which on the client end looks exactly like you described. What is odd is that you say it is repeatable. What could be sending SIGINT to the postmaster whenever you try to connect? Are database server and web server on the same machine? Try to find out what is going on there. How does the log look when you enable log_connections and log_disconnections in postgresql.conf? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
