psql tends to do things like this: rhaas=# select * from pg_stat_activity; FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
Basically everything psql has to say about this is a lie: 1. It says the server closed the connection unexpectedly, but it just finished processing a FATAL message from the server. So how unexpected is it that the connection would thereafter be closed? 2. It says the server probably terminated abnormally, but PostgreSQL is rarely so unreliable as to just give up the ghost and die. The ErrorResponse it just processed has an errcode of ERRCODE_ADMIN_SHUTDOWN, so probably what happened is somebody either shut down the server or killed the session. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers