Ghost open transaction

[Naz Gassiep <naz@xxxxxxxx>]

I was performing a bunch of INSERTs into a table, users, that has a 
unique index on username. During the transaction, my internet connection 
dropped. The INSERTs were being done inside a transaction.

Once I had manhandled my DSL router back online, I went back into a 
console to redo the inserts. I found that after I did the first insert, 
it appeared to freeze. I thought that my net had dropped out again, but 
I was able to Ctrl+C the command and rollback and do it again, with the 
same result. The previous connection is obviously still active, locking 
the transaction until the fate of the previous insert with that username 
is known, i.e., the ghost connection rolls back or commits.

How do I determine which connection is the ghost connection, and how do 
I tell PG to kill it? Also, is it an OS setting to determine the timeout 
on open but inactive connections, or a PG setting?

- Naz.