Re: How to use pg_waldump? - Mailing list pgsql-general

Hi André,

> On 01. May, 2020, at 14:33, André Hänsel <andre@webkr.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@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_SHUTDOWNredo B/E4000028; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid
561in 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
nextXid6641 latestCompletedXid 6640 oldestRunningXid 6641 
rmgr: Standby     len (rec/tot):     50/    50, tx:          0, lsn: B/E40000D8, prev B/E40000A0, desc: RUNNING_XACTS
nextXid6641 latestCompletedXid 6640 oldestRunningXid 6641 
rmgr: XLOG        len (rec/tot):    114/   114, tx:          0, lsn: B/E4000110, prev B/E40000D8, desc:
CHECKPOINT_ONLINEredo B/E40000D8; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid
561in 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
nextXid6641 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_SHUTDOWNredo B/E6000028; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid
561in 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
nextXid6641 latestCompletedXid 6640 oldestRunningXid 6641 
rmgr: Standby     len (rec/tot):     50/    50, tx:          0, lsn: B/E60000D8, prev B/E60000A0, desc: RUNNING_XACTS
nextXid6641 latestCompletedXid 6640 oldestRunningXid 6641 
rmgr: XLOG        len (rec/tot):    114/   114, tx:          0, lsn: B/E6000110, prev B/E60000D8, desc:
CHECKPOINT_ONLINEredo B/E60000D8; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid
561in 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
nextXid6641 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_SHUTDOWNredo B/E8000028; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid
561in 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
nextXid6641 latestCompletedXid 6640 oldestRunningXid 6641 
rmgr: Standby     len (rec/tot):     50/    50, tx:          0, lsn: B/E80000D8, prev B/E80000A0, desc: RUNNING_XACTS
nextXid6641 latestCompletedXid 6640 oldestRunningXid 6641 
rmgr: XLOG        len (rec/tot):    114/   114, tx:          0, lsn: B/E8000110, prev B/E80000D8, desc:
CHECKPOINT_ONLINEredo B/E80000D8; tli 79; prev tli 79; fpw true; xid 0:6641; oid 37940; multi 1; offset 0; oldest xid
561in 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
nextXid6641 latestCompletedXid 6640 oldestRunningXid 6641 
rmgr: XLOG        len (rec/tot):     24/    24, tx:          0, lsn: B/E80001C0, prev B/E8000188, desc: SWITCH

Cheers,
Paul