Restart the vertica database from the command line

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How can I stop and start the vertica database from the command line?

Environment

Dx NetOps Performance Management any version

Resolution

You stop the vertica database by doing the following:

On the data repository, as the dradmin user:

1. cd /opt/vertica/bin

2. -bash-4.1$ ./admintools -t stop_db -F -d <database>-p <password>

        Issuing shutdown command to database

Database drdata stopped successfully

 

To start the database back up do the following:

On the data repository, as the dradmin user:

1. cd /opt/vertica/bin

2. -bash-4.1$ ./admintools -t start_db  -d <database>

Info: no password specified, using none

        Starting nodes:

                v_drdata_node0001 (xx.xxx.xx.xxx)

                v_drdata_node0002 (xx.xxx.xx.xxx)

                v_drdata_node0003 (xx.xxx.xx.xxx)

 

        Starting Vertica on all nodes. Please wait, databases with large catalogs may take a while to initialize.

 

        Node Status: v_drdata_node0001: (INITIALIZING) v_drdata_node0002: (INITIALIZING) v_drdata_node0003: (INITIALIZING)

        Node Status: v_drdata_node0001: (INITIALIZING) v_drdata_node0002: (INITIALIZING) v_drdata_node0003: (INITIALIZING)

        Node Status: v_drdata_node0001: (INITIALIZING) v_drdata_node0002: (INITIALIZING) v_drdata_node0003: (INITIALIZING)

        Node Status: v_drdata_node0001: (UP) v_drdata_node0002: (UP) v_drdata_node0003: (UP)

Database drdata started successfully