pg_waldump and PREPARE

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема pg_waldump and PREPARE
Дата
Msg-id CAHGQGwEvhASad4JJnCv=0dW2TJypZgW_Vpb-oZik2a3utCqcrA@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_waldump and PREPARE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Hi,

pg_waldump report no detail information about PREPARE TRANSACTION record,
as follows.

    rmgr: Transaction len (rec/tot):    250/   250, tx:        485,
lsn: 0/020000A8, prev 0/02000060, desc: PREPARE

I'd like to modify pg_waldump, i.e., xact_desc(), so that it reports
detail information like GID, as follows. Attached patch does that.
This would be helpful, for example, when diagnosing 2PC-related
trouble by checking the status of 2PC transaction with the specified GID.
Thought?

    rmgr: Transaction len (rec/tot):    250/   250, tx:        485,
lsn: 0/020000A8, prev 0/02000060, desc: PREPARE gid abc: 2004-06-17
05:26:27.500240 JST

I will add this to next CommitFest page.

Regards,

-- 
Fujii Masao

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: TRACE_SORT defined by default