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