OS Manuals

/usr/lib/postgresql/17/bin/pg_waldump

commercial-spilo-4 compat package

From commercial-spilo-4-compat 4.1.2-r17 (enterprise-packages), captured 2026-11-08 by running pg_waldump --help (exit 0). permalink

pg_waldump decodes and displays PostgreSQL write-ahead logs for debugging.

Usage:
  pg_waldump [OPTION]... [STARTSEG [ENDSEG]]

Options:
  -b, --bkp-details      output detailed information about backup blocks
  -B, --block=N          with --relation, only show records that modify block N
  -e, --end=RECPTR       stop reading at WAL location RECPTR
  -f, --follow           keep retrying after reaching end of WAL
  -F, --fork=FORK        only show records that modify blocks in fork FORK;
                         valid names are main, fsm, vm, init
  -n, --limit=N          number of records to display
  -p, --path=PATH        directory in which to find WAL segment files or a
                         directory with a ./pg_wal that contains such files
                         (default: current directory, ./pg_wal, $PGDATA/pg_wal)
  -q, --quiet            do not print any output, except for errors
  -r, --rmgr=RMGR        only show records generated by resource manager RMGR;
                         use --rmgr=list to list valid resource manager names
  -R, --relation=T/D/R   only show records that modify blocks in relation T/D/R
  -s, --start=RECPTR     start reading at WAL location RECPTR
  -t, --timeline=TLI     timeline from which to read WAL records
                         (default: 1 or the value used in STARTSEG)
  -V, --version          output version information, then exit
  -w, --fullpage         only show records with a full page write
  -x, --xid=XID          only show records with transaction ID XID
  -z, --stats[=record]   show statistics instead of records
                         (optionally, show per-record statistics)
  --save-fullpage=DIR    save full page images to DIR
  -?, --help             show this help, then exit

Report bugs to <pgsql-bugs@lists.postgresql.org>.
PostgreSQL home page: <https://www.postgresql.org/>
Options (18)
OptionDescriptionSource
-b, --bkp-detailsoutput detailed information about backup blockshelp
-B, --block Nwith --relation, only show records that modify block Nhelp
-e, --end RECPTRstop reading at WAL location RECPTRhelp
-f, --followkeep retrying after reaching end of WALhelp
-F, --fork FORKonly show records that modify blocks in fork FORK;help
-n, --limit Nnumber of records to displayhelp
-p, --path PATHdirectory in which to find WAL segment files or a directory with a ./pg_wal that contains such files (default: current directory, ./pg_wal, $PGDATA/pg_wal)help
-q, --quietdo not print any output, except for errorshelp
-r, --rmgr RMGRonly show records generated by resource manager RMGR;help
-R, --relation T/D/Ronly show records that modify blocks in relation T/D/Rhelp
-s, --start RECPTRstart reading at WAL location RECPTRhelp
-t, --timeline TLItimeline from which to read WAL records (default: 1 or the value used in STARTSEG)help
-V, --versionoutput version information, then exithelp
-w, --fullpageonly show records with a full page writehelp
-x, --xid XIDonly show records with transaction ID XIDhelp
-z, --stats recordshow statistics instead of records (optionally, show per-record statistics)help
--save-fullpage DIRsave full page images to DIRhelp
-?, --helpshow this help, then exithelp

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.