Stuck "idle in transaction (aborted)"

[Nimesh Satam <nimesh.zedo@xxxxxxxxx>]

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.