Getting SQL commands from WALs

Поиск
Список
Период
Сортировка
От Vladimir Borodin
Тема Getting SQL commands from WALs
Дата
Msg-id 3EBA8C2B-E8D5-44F8-A27C-CEC40C20D70F@simply.name
обсуждение исходный текст
Список pgsql-admin
Hi all.

Is there a way to get raw SQL commands from WALs on file system if you use wal_level = logical? Something like pg_xlogdump but in human-readable SQL commands. And without creating logical replication slot. It might be useful to get list of lost changes from old master after failover to understand what kind of changes you lost.

Thanks in advance.

--
May the force be with you…

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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: bitmap_heap_scan vs sequential scan
Следующее
От: CS DBA
Дата:
Сообщение: repmgr error trying to clone - permission denied