Restart a single node vertica database from the command line

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How can we stop and start a single node vertica database from the command line

Environment

Dx NetOps Performance Management any version

Resolution

As the dradmin user

• To see the cluster state:  /opt/vertica/bin/adminTools -t view_cluster
• To stop the database:  /opt/vertica/bin/admintools -t stop_node --hosts <node IP address>
• To start the database: /opt/vertica/bin/admintools -t start_db  --database <database name>