D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
opt
/
td-agent
/
embedded
/
share
/
man
/
man1
/
Filename :
pg_xlogdump.1
back
Copy
'\" t .\" Title: pg_xlogdump .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets v1.76.1 <http://docbook.sf.net/> .\" Date: 2014 .\" Manual: PostgreSQL 9.3.5 Documentation .\" Source: PostgreSQL 9.3.5 .\" Language: English .\" .TH "PG_XLOGDUMP" "1" "2014" "PostgreSQL 9.3.5" "PostgreSQL 9.3.5 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" pg_xlogdump \- Display a human\-readable rendering of the write\-ahead log of a PostgreSQL database cluster .\" pg_xlogdump .SH "SYNOPSIS" .HP \w'\fBpg_xlogdump\fR\ 'u \fBpg_xlogdump\fR [\fBoption\fR...] [\fBstartseg\fR\ [\fBendseg\fR]] .SH "DESCRIPTION" .PP \fBpg_xlogdump\fR displays the write\-ahead log (WAL) and is mainly useful for debugging or educational purposes\&. .PP This utility can only be run by the user who installed the server, because it requires read\-only access to the data directory\&. .SH "OPTIONS" .PP The following command\-line options control the location and format of the output: .PP \fIstartseg\fR .RS 4 Start reading at the specified log segment file\&. This implicitly determines the path in which files will be searched for, and the timeline to use\&. .RE .PP \fIendseg\fR .RS 4 Stop after reading the specified log segment file\&. .RE .PP \fB\-b\fR, \fB\-\-bkp\-details\fR .RS 4 Output detailed information about backup blocks\&. .RE .PP \fB\-e \fR\fB\fIend\fR\fR, \fB\-\-end=\fR\fB\fIend\fR\fR .RS 4 Stop reading at the specified log position, instead of reading to the end of the log stream\&. .RE .PP \fB\-n \fR\fB\fIlimit\fR\fR, \fB\-\-limit=\fR\fB\fIlimit\fR\fR .RS 4 Display the specified number of records, then stop\&. .RE .PP \fB\-p \fR\fB\fIpath\fR\fR, \fB\-\-path=\fR\fB\fIpath\fR\fR .RS 4 Directory in which to find log segment files\&. The default is to search for them in the pg_xlog subdirectory of the current directory\&. .RE .PP \fB\-r \fR\fB\fIrmgr\fR\fR, \fB\-\-rmgr=\fR\fB\fIrmgr\fR\fR .RS 4 Only display records generated by the specified resource manager\&. If list is passed as name, print a list of valid resource manager names, and exit\&. .RE .PP \fB\-s \fR\fB\fIstart\fR\fR, \fB\-\-start=\fR\fB\fIstart\fR\fR .RS 4 Log position at which to start reading\&. The default is to start reading the first valid log record found in the earliest file found\&. .RE .PP \fB\-t \fR\fB\fItimeline\fR\fR, \fB\-\-timelime=\fR\fB\fItimeline\fR\fR .RS 4 Timeline from which to read log records\&. The default is to use the value in startseg, if that is specified; otherwise, the default is 1\&. .RE .PP \fB\-V\fR, \fB\-\-version\fR .RS 4 Print the pg_xlogdump version and exit\&. .RE .PP \fB\-x \fR\fB\fIxid\fR\fR, \fB\-\-xid=\fR\fB\fIxid\fR\fR .RS 4 Only display records marked with the given TransactionId\&. .RE .PP \fB\-?\fR, \fB\-\-help\fR .RS 4 Show help about pg_xlogdump command line arguments, and exit\&. .RE .SH "NOTES" .PP Can give wrong results when the server is running\&. .PP Only the specified timeline is displayed (or the default, if none is specified)\&. Records in other timelines are ignored\&. .SH "SEE ALSO" Section 29.5, \(lqWAL Internals\(rq, in the documentation