Postgres Pro
Downloads
Home   >   mailing lists

Re: finding the procpid (or pid) for a prepared transaction - Mailing list pgsql-admin

From Tom Lane
Subject Re: finding the procpid (or pid) for a prepared transaction
Date
Msg-id 18661.1297995564@sss.pgh.pa.us
Whole thread Raw
In response to finding the procpid (or pid) for a prepared transaction  (CS DBA <cs_dba@consistentstate.com>)
Responses Re: finding the procpid (or pid) for a prepared transaction
List pgsql-admin
Tree view 
CS DBA <cs_dba@consistentstate.com> writes:
> I have several prepared tx which are running for a long long time. I
> want to kill 'em but I dont know the process id.

If they're prepared, they're *not* running, and they don't have a
process id.  They're just going to sit there until you do COMMIT
PREPARED or ROLLBACK PREPARED.

            regards, tom lane

pgsql-admin by date:

Previous
From: CS DBA
Date:
Subject: finding the procpid (or pid) for a prepared transaction
Next
From: CS DBA
Date:
Subject: Re: finding the procpid (or pid) for a prepared transaction