Re: Getting transaction details from the WAL?

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Getting transaction details from the WAL?
Дата
Msg-id 72F6C54D-3787-4016-B765-45672851FD72@thebuild.com
обсуждение исходный текст
Ответ на Getting transaction details from the WAL?  (Bo Guo <bo.guo@gisticinc.com>)
Ответы Re: Getting transaction details from the WAL?  (Bo Guo <bo.guo@gisticinc.com>)
Список pgsql-sql

> On May 22, 2021, at 19:00, Bo Guo <bo.guo@gisticinc.com> wrote:
>
> I am wondering if it is possible to get content changes to a particular table from a point-in-time by exploring the
WALor any other artifacts relating to transaction management. 

Perhaps the easiest way to do this is to use logical decoding, which you can use to capture changes from the WAL,
convertingthem to other formats.  While it forms the basis of logical replication, there are other plug-ins to the
framework. You might look at wal2json: 

    https://github.com/eulerto/wal2json

or the test plugin in contrib/

    https://www.postgresql.org/docs/current/test-decoding.html


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

Предыдущее
От: Bo Guo
Дата:
Сообщение: Getting transaction details from the WAL?
Следующее
От: Bo Guo
Дата:
Сообщение: Re: Getting transaction details from the WAL?