How to shutdown Vertica from the command line

Products

• CA Performance Management
• Network Observability

Issue/Introduction

How can I shutdown vertica from the command line prior to patching my Data Repository?

Environment

Dx NetOps Performance Management any version

Resolution

Simply run the following command as the dradmin user:

• /opt/vertica/bin/vsql -w dbpassword -c "SELECT SHUTDOWN('true');"

This will force a graceful shutdown of vertica

Additional Information

To start the DB again, you can run the following as "dradmin"

"/opt/vertica/bin/adminTools -t start_db -d <DB_Name> -p <DB_PW> -i";

To view the state of the cluster

./admintools -t view_cluster