Stuck "idle in transaction (aborted)"

From: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Stuck "idle in transaction (aborted)"
Date: 2011-01-14 04:01:25
Message-ID: AANLkTin0AP=qdw7xXWi=gXXNss=G04mfKfm8=HYkHedq@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,
Nimesh.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-01-14 05:51:33 Re: database is growing... 1GB per day basis
Previous Message Tom Lane 2011-01-14 00:23:30 Re: Inconsistent time interval formatting