Re: How to use pg_waldump?

Hi André,

> On 01. May, 2020, at 14:33, André Hänsel <andre(at)webkr(dot)de> wrote:
>
> Picking a random WAL file and running the command gives me:
>
> pg_waldump: FATAL: could not find a valid record after 2F/6C000000

maybe try with another WAL file or files?

Works for me...

postgres(at)weasel:~$ pg_waldump -p /data/wal 0000004F0000000B00000072 0000004F0000000B00000074
rmgr: XLOG len (rec/tot): 114/ 114, tx: 0, lsn: B/E4000028, prev B/E20001C0, desc: CHECKPOINT_SHUTDOWN redo B/E4000028; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid 561 in DB 16400; oldest multi 1 in DB 16401; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; shutdown
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E40000A0, prev B/E4000028, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E40000D8, prev B/E40000A0, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: XLOG len (rec/tot): 114/ 114, tx: 0, lsn: B/E4000110, prev B/E40000D8, desc: CHECKPOINT_ONLINE redo B/E40000D8; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid 561 in DB 16400; oldest multi 1 in DB 16401; oldest/newest commit timestamp xid: 0/0; oldest running xid 6641; online
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E4000188, prev B/E4000110, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: XLOG len (rec/tot): 24/ 24, tx: 0, lsn: B/E40001C0, prev B/E4000188, desc: SWITCH
rmgr: XLOG len (rec/tot): 114/ 114, tx: 0, lsn: B/E6000028, prev B/E40001C0, desc: CHECKPOINT_SHUTDOWN redo B/E6000028; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid 561 in DB 16400; oldest multi 1 in DB 16401; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; shutdown
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E60000A0, prev B/E6000028, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E60000D8, prev B/E60000A0, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: XLOG len (rec/tot): 114/ 114, tx: 0, lsn: B/E6000110, prev B/E60000D8, desc: CHECKPOINT_ONLINE redo B/E60000D8; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid 561 in DB 16400; oldest multi 1 in DB 16401; oldest/newest commit timestamp xid: 0/0; oldest running xid 6641; online
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E6000188, prev B/E6000110, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: XLOG len (rec/tot): 24/ 24, tx: 0, lsn: B/E60001C0, prev B/E6000188, desc: SWITCH
rmgr: XLOG len (rec/tot): 114/ 114, tx: 0, lsn: B/E8000028, prev B/E60001C0, desc: CHECKPOINT_SHUTDOWN redo B/E8000028; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid 561 in DB 16400; oldest multi 1 in DB 16401; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; shutdown
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E80000A0, prev B/E8000028, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E80000D8, prev B/E80000A0, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: XLOG len (rec/tot): 114/ 114, tx: 0, lsn: B/E8000110, prev B/E80000D8, desc: CHECKPOINT_ONLINE redo B/E80000D8; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid 561 in DB 16400; oldest multi 1 in DB 16401; oldest/newest commit timestamp xid: 0/0; oldest running xid 6641; online
rmgr: Standby len (rec/tot): 50/ 50, tx: 0, lsn: B/E8000188, prev B/E8000110, desc: RUNNING_XACTS nextXid 6641 latestCompletedXid 6640 oldestRunningXid 6641
rmgr: XLOG len (rec/tot): 24/ 24, tx: 0, lsn: B/E80001C0, prev B/E8000188, desc: SWITCH

Cheers,
Paul