pg_resetxlog

Function

pg_resetxlog is a tool for re-setting database transaction files.

Prerequisites

Ensure that the database directory exists and is correct.

Syntax

pg_resetxlog [OPTION]... DATADIR

Parameter Description

OPTION is described as follows:

• DATADIR

  Database directory to be modified. Ensure that the directory is correct.

• -e XIDEPOCH

  Sets the period of the next transaction ID.

• -f

  Forcibly updates transaction files.

• -l xlogfile

  Forcibly specifies the minimum point of the new transaction log in the Xlog file.

• -m XID

  Sets the next multitransaction ID.

• -n

  Displays the value in the configuration file without update.

• -o OID

  Sets the next OID.

• -O OFFSET

  Sets the offset of the next multitransaction.

• -V, -version

  Displays version information.

• -x XID

  Sets the next transaction ID.

• -?, -help

  Displays help information.