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.

See Also