Getting SQL commands from WALs - Mailing list pgsql-admin

From Vladimir Borodin
Subject Getting SQL commands from WALs
Date
Msg-id 3EBA8C2B-E8D5-44F8-A27C-CEC40C20D70F@simply.name
Whole thread Raw
List 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 by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: bitmap_heap_scan vs sequential scan
Next
From: CS DBA
Date:
Subject: repmgr error trying to clone - permission denied