- stretch 9.6.12-0+deb9u1
PG_XLOGDUMP(1) | PostgreSQL 9.6.12 Documentation | PG_XLOGDUMP(1) |
NAME¶
pg_xlogdump - display a human-readable rendering of the write-ahead log of a PostgreSQL database clusterSYNOPSIS¶
pg_xlogdump [option...] [startseg [endseg]]
DESCRIPTION¶
pg_xlogdump displays the write-ahead log (WAL) and is mainly useful for debugging or educational purposes.This utility can only be run by the user who installed the server, because it requires read-only access to the data directory.
OPTIONS¶
The following command-line options control the location and format of the output:startseg
endseg
-b
--bkp-details
-e end
--end=end
-f
--follow
-n limit
--limit=limit
-p path
--path=path
-r rmgr
--rmgr=rmgr
-s start
--start=start
-t timeline
--timeline=timeline
-V
--version
-x xid
--xid=xid
-z
--stats[=record]
-?
--help
NOTES¶
Can give wrong results when the server is running.Only the specified timeline is displayed (or the default, if none is specified). Records in other timelines are ignored.
pg_xlogdump cannot read WAL files with suffix .partial. If those files need to be read, .partial suffix needs to be removed from the file name.
SEE ALSO¶
Section 30.5, “WAL Internals”, in the documentation2019 | PostgreSQL 9.6.12 |