5.5 Stopping and Starting Vertica Services
NOTE:ZENworks has two sets of commands to stop/start Vertica. They are new commands and old commands.
-
New Commands: These commands are available on appliances that have security patches of version 20.2.0-2022.10.29 or later installed. The old set of commands is not available here.
-
Old Commands: These commands are available on appliances that do not have the security patches of version 20.2.0-2022.10.29 or later installed.
Based on the security patches version installed on your appliance, you can follow the appropriate set of commands. To identify whether you have the required security patch version, run the following command:
rpm -q --queryformat='%{Version}-%{Release}\n' zen-appliance-version
5.5.1 Vertica Services on ZENworks 2020 Update 2
To stop and start the Vertica services, you need to login as a dbadmin user by running the following command: su dbadmin
IMPORTANT:It is highly recommended that you stop the nodes on the Vertica cluster before shutting down the ZENworks Appliance for maintenance.
-
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:
-
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.
-
Select .
-
Select and click . The database name is displayed within the attribute.
