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 OpenText™ Analytics Database 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