On 01/14/2011 12:01 PM, Nimesh Satam wrote:
Hi, We have a stale connection on one of our machine. The connection is shown as follows: 26286 ? Ss 1:31 postgres: postgres reporting localhost (37118) idle in transaction (aborted) Can anybody let me know how we can get rid of such connection, is there are any command which will kill such a aborted transaction in a safe manner?
psql> select pg_terminate_backend(26286); or shell$> kill 26286 Do ***NOT*** use "kill -9" or "kill -KILL". -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
