pg_resetxlog

Function

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

CAUTION: Before running the pg_resetxlog command, stop the database.

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 next transaction ID.

• -f

  Forcibly updates transaction files.

• -l xlogfile

  Specifies the smallest WAL start position for new transaction logs.

• -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.