5.5 Stopping and Starting Vertica Services

To stop and start the Vertica services, you need to login as a dbadmin user by running the following command: su dbadmin

  • Execute the following to stop the Vertica services:

    $ /opt/vertica/bin/admintools -t stop_db -d <db_name> -p <password> -F

    Use the option -F (or --force) to override all user connections and force a shutdown:

  • Execute the following command, to start the Vertica services:

    $ /opt/vertica/bin/admintools -t start_db -d <db_name> -p <password>

Specify the dbadmin superuser password in both the commands that can be obtained by executing the following:

zman server-role-vertica-get-credentials (zman srvgc)

To obtain the database name, navigate to the zenworks-coreadmin web service by referring to the following steps:

  1. On your browser, type the server address of the Primary Server that is part of the Vertica cluster, along with zenworks-coreadmin. For example: https://10.0.0.0/zenworks-coreadmin.

  2. Select Test Service.

  3. Select Vertica Configuration and click Invoke. The database name is displayed within the Database attribute.