finding the procpid (or pid) for a prepared transaction

Поиск
Список
Период
Сортировка
От CS DBA
Тема finding the procpid (or pid) for a prepared transaction
Дата
Msg-id 4D5DD51C.30600@consistentstate.com
обсуждение исходный текст
Ответы Re: finding the procpid (or pid) for a prepared transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi All;

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. I can get the xid via
pg_prepared_xacts.transaction however the tx's have no locks thus no
corresponding pg_locks row.  Anyone know how I can get a procpid based
on a tx id?


Thanks in advance...


В списке pgsql-admin по дате отправления:

Предыдущее
От: Selva manickaraja
Дата:
Сообщение: Re: Trigger File Behaviour
Следующее
От: Tom Lane
Дата:
Сообщение: Re: finding the procpid (or pid) for a prepared transaction