start_db

Starts a database and establishes cluster quorum.

The IP address provided for each node name must match the current IP address in the Vertica catalog. If the IPs do not match, you must first run re_ip to inform the database of the updated IP addresses.

If you pass the --hosts option a subset of all nodes in the cluster, only the specified nodes are started, and the specified subset must be a quorum of nodes.

Syntax

vcluster start_db options

Required options

{ -c | --config } string

The path to the configuration file. If a configuration file is present in the default location (automatically generated by create_db), you do not need to specify this option.

Default: /opt/vertica/config/vertica_cluster.yaml

Options

--ca-cert-file string

The path to the trusted CA certificate file.

Default: /opt/vertica/config/https_certs/rootca.pem

--catalog-path string

The absolute path to the catalog directory.

--cert-file string

The absolute path to the certificate file. If you specify this option, you must also specify --key-file. You should only use --cert-file and --key-file if you have configured the Node Management Agent (NMA) to use custom certificates.

--communal-storage-location string

[Eon only] The absolute path of your communal storage location.

--config-param PARAMETER=VALUE[,...]

A comma-separated list of PARAMETER=VALUE pairs. Parameters specified with this option override the ones in configuration files, if any, and take the following parameters:

• AWSAuth
• AWSEndpoint
• AWSEnableHttps
• AWSRegion

--config-param-file string

The absolute path to a file containing configuration parameters and their values.

--eon-mode

[Eon only] Indicates that the database is an Eon Mode database.

--epoch string

[Enterprise only] Specifies the epoch from which the database should start. If --epoch last is provided, the database starts from the last known good epoch.

Caution

This option may result in data loss.

{ -h | --help }

Prints help text.

--hosts strings

A comma-separated list of hosts in the database.

--ipv6

Specifies if the hosts use IPv6 addresses.

Default: IPv4

--key-file string

Path to the key file. If you specify this option, you must also specify --cert-file. You should only use --cert-file and --key-file if you have configured the Node Management Agent (NMA) to use custom certificates.

{ -l | --log-path } string

The absolute path for debug logs.

Default: /opt/vertica/log/vcluster.log

--main-cluster-only

Starts the database on a main cluster and does not start any sandboxes.

{ -p | --password } string

The database password.

--password-file string

The absolute path to a file containing the database password.

If you pass a dash(-) (that is, `--password-file -`), the password is read from STDIN.

Important

Your database password cannot include single quotes.

--read-password-from-prompt

Prompts the user to enter the password.

--sandbox string

Name of the sandbox to start.

--sync-catalog

Whether to sync the catalog after all nodes are up.

--timeout int

The time (in seconds) to wait for nodes to start up. Extend this value to allow additional time (for example, 3600 for one hour).

Default: 300

--tls-mode string

Sets the TLS validation mode. Valid options are enable, verify-ca, verify-full.

Default: enable

--use-password-for-sql-client-only

Use the password for the NMA SQL client only.

--verbose

Shows the details of VCluster run in the console.

Examples

To start a database

$ vcluster start_db --password my_password \
  --config /opt/vertica/config/vertica_cluster.yaml

To start a datbase from the last good epoch:

Return the last good epoch:

vcluster return_epoch

Start from the last good epoch:

vcluster start_db --epoch 1234