Thread: Getting SQL commands from WALs

Getting SQL commands from WALs

From
Vladimir Borodin
Date:
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…