Getting SQL commands from WALs

From: Vladimir Borodin <root(at)simply(dot)name>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Getting SQL commands from WALs
Date: 2015-09-26 18:10:30
Message-ID: 3EBA8C2B-E8D5-44F8-A27C-CEC40C20D70F@simply.name
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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…
https://simply.name

Browse pgsql-admin by date

  From Date Subject
Next Message CS DBA 2015-09-28 17:35:19 repmgr error trying to clone - permission denied
Previous Message Albe Laurenz 2015-09-25 08:43:52 Re: bitmap_heap_scan vs sequential scan