How to shutdown Vertica from the command line

Document ID : KB000117409
Last Modified Date : 11/10/2018
Show Technical Document Details
Question:
How can I shutdown vertica from the command line prior to patching my Data Repository?
Environment:
Any CAPM ennvironment
Answer:
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