"Abraham, Danny" <danny_abraham@xxxxxxx> wrote: > procpid | current_query > ---------+--------------------------------------------------------------------- > 25936 | <IDLE> in transaction <== This is the locker > - What exactly is the locker doing? At the time you ran that, it wasn't doing anything in the database, but it had not committed or rolled back the transaction it had previously started. > - Can I retrieve the Client PID somewhere (then by process name I > will dive into the code). If you're on Linux and this is a TCP connection, netstat should make that easy. Are you? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
