ALTER DATABASE

Use ALTER DATABASE to perform the following tasks:

• Drop all fault groups and their child fault groups from a database.
• Restore down nodes, and revert active standby nodes to standby status.
• Specify the subnet name of a public network to use for import/export.
• Set and clear database configuration parameters.

To see the current value of a parameter, use SHOW DATABASE.

Syntax

ALTER DATABASE db-spec {
      DROP ALL FAULT GROUP
      | EXPORT ON { subnet‑name | DEFAULT } 
      | RESET STANDBY
      | SET [PARAMETER] parameter=value [,…] 
      | CLEAR [PARAMETER] parameter[,…]
}

Parameters

db-spec	Specifies the database to alter, one of the following: The database name DEFAULT: The current database
DROP ALL FAULT GROUP	Drops all fault groups defined on the specified database.
EXPORT ON	Specifies the network to use for importing and exporting data, one of the following: subnet‑name: A subnet of the public network. DEFAULT: Specifies to use a private network. For details, see Identify the Database or Nodes Used for Import/Export, and Changing Node Export Addresses.
RESET STANDBY	Restores any replaced nodes and reverts all active standby nodes to standby status. If any replaced nodes cannot resume activity, Vertica leaves the standby nodes in place.
SET [PARAMETER] parameter=value	Sets parameter to the specified value.
CLEAR [PARAMETER] parameter	Resets parameter to its default value.

Privileges

Superuser