gs_clean

Background

If the database breaks down unexpectedly, residual temporary tables may exist. gs_clean can be used to clear the residual temporary tables.

Syntax

Connect to the primary DN and clear the residual temporary table of the primary DN transaction.

gs_clean [OPTION ...] [USERNAME]

Parameter Description

OPTION is described as follows:

• -a, --all

  Clears all residual temporary tables in available databases.

• -h, --host=HOSTADDRESS

  Specifies the IP address of the host where the target DN is located.

  Value range: the IP address of the host where the target DN is located.

  Default value: localhost

• -p, --port=PORT

  Specifies the port number of the primary DN.

  Value range: port number of the target DN.

  The default value is 5432. If the environment variable PGPORT of the OS has been set, the value of PGPORT is used by default.

• -q, --quiet

  Prints only error information in quiet mode.

• -r, --rollback

  Rolls back all abnormal transactions.

• -t, --timeout=SECS

  Specifies the timeout mechanism.

  Default value: 5s Unit: s

• -U, --username=USERNAME

  Specifies the name of the user for connecting to the database.

  Value range: a valid username in the database

  Default value: OS username

• -v, --verbose

  Prints detailed restoration information.

• -V, --version

  Prints version information about gs_clean.

• -w, --no-password

  Specifies that no password authentication is required.

• -W, --password=PASSWORD

  Specifies that password authentication is required.

  Value range: a valid string. The password must meet the complexity requirement.

• -e, --exclusive

  Cleans temporary tables only.

• -j, --jobs

  Specifies the number of jobs for cleaning two-phase residual files.

  Value range: 1–10

  Default value: 3

• -?, --help

  Displays help information.