Starting the Database

You can start a database through one of the following:

Administration Tools

  1. Open the Administration Tools and select View Database Cluster State to make sure that all nodes are down and that no other database is running.
  2. Open the Administration Tools. See Using the Administration Tools for information about accessing the Administration Tools.
  3. On the Main Menu, select Start Database,and then select OK.

  4. Select the database to start, and then click OK.

    You should start only one database at a time. If you start more than one database at any time, the results can be unpredictable. Users might encounter resource conflicts or perform operations on the wrong database.

  5. Enter the database password and click OK.
  6. When prompted that the database started successfully, click OK.
  7. Check the log files to make sure that no startup problems occurred.

Command Line

You can start a database with the command line tool start_db:

$ /opt/vertica/bin/admintools -t start_db -d db-name
     [-p password] [-F]
Option Description
‑p
‑‑password

Required only during database creation, when you install a new license.

If the license is valid, the option -p (or --password) is not required to start the database and is silently ignored. This is by design, as the database can only be started by the user who (as part of the verticadba UNIX user group) initially created the database or who has root or su privileges.

If the license is invalid, Vertica uses the -p password argument to attempt to upgrade the license with the license file stored in /opt/vertica/config/share/license.key.
‑F

‑‑force

Forces the database to start at an epoch that precedes detection of data consistency problems

Following is an example of using start_db on a standalone node: 

$ /opt/vertica/bin/admintools -t start_db -d VMart
Info:
no password specified, using none
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (DOWN) 
Node Status: v_vmart_node0001: (UP) 
Database VMart started successfully