pg_waldump
all
Display a human-readable rendering of the write-ahead log (WAL) of a PostgreSQL database cluster.
More info →Options (6)
-p, --pathbooleanSpecify the WAL file directory
Example:
pg_waldump {{start_segment}} {{end_segment}} {{[-p|--path]}} {{path}}-f, --followbooleanFollow new WAL entries as they arrive
Example:
pg_waldump {{start_segment}} {{end_segment}} {{[-f|--follow]}}-n, --limitbooleanLimit number of records shown
Example:
pg_waldump {{start_segment}} {{end_segment}} {{[-n|--limit]}} {{count}}-z, --statsbooleanDisplay summary statistics instead of individual records
Example:
pg_waldump {{start_segment}} {{end_segment}} {{[-z|--stats]}}-r, --rmgrbooleanFilter by resource manager
Example:
pg_waldump {{start_segment}} {{end_segment}} {{[-r|--rmgr]}} {{rmgr_name}}--helpbooleanDisplay help
Example:
pg_waldump {{[-?|--help]}}Examples (8)
Display WAL records from a specific segment
pg_waldump start_segmentDisplay WAL records between two segments
pg_waldump start_segment end_segmentSpecify the WAL file directory
pg_waldump start_segment end_segment [-p|--path] pathFollow new WAL entries as they arrive
pg_waldump start_segment end_segment [-f|--follow]Limit number of records shown
pg_waldump start_segment end_segment [-n|--limit] countDisplay summary statistics instead of individual records
pg_waldump start_segment end_segment [-z|--stats]Filter by resource manager
pg_waldump start_segment end_segment [-r|--rmgr] rmgr_nameDisplay help
pg_waldump [-?|--help]made by @shridhargupta | data from tldr-pages