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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
