Обсуждение: Getting SQL commands from WALs

Поиск
Список
Период
Сортировка

Getting SQL commands from WALs

От
Vladimir Borodin
Дата:
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…