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.