Hi André, > On 01. May, 2020, at 14:33, André Hänsel <andre@xxxxxxxx> 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_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
