ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Restart a single node vertica database from the command line

book

Article ID: 226942

calendar_today

Updated On:

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>