CREATE FAULT GROUP
Creates a fault group, which can contain the following:
- One or more nodes
- One or more child fault groups
- One or more nodes and one or more child fault groups
The CREATE FAULT GROUP
statement creates an empty fault group. You must run the ALTER FAULT GROUP
statement to add nodes or other fault groups to an existing fault group.
Prior to Vertica version 9.3.0, fault groups defined subclusters in Eon Mode databases. Starting in 9.3.0, you can directly create subclusters. This statement works when the database is in Eon Mode. However, fault groups in an Eon Mode database have no effect, and you are unable to manipulate the fault group in any way. Eon Mode databases upgraded from versions earlier than 9.3.0 have their fault groups automatically converted to subclusters. See Subclusters for more information.
Fault groups continue to work as before in Enterprise Mode databases.
Syntax
CREATE FAULT GROUP name
Parameters
name |
The name of the fault group to create, unique among all fault groups, where name conforms to conventions described in Identifiers. |
Privileges
Superuser
Example
The following command creates a fault group called parent0
:
=> CREATE FAULT GROUP parent0; CREATE FAULT GROUP
To add nodes or other fault groups to the parent0
fault group, run the ALTER FAULT GROUP
statement.