How to start and stop Vertica from admintools comand line

Using the admintools command line we can create all types of routines and scripts.

  • To start your database using the admintools command line:
  • [dbadmin@bih001 ~]$ admintools -t start_db -F -d test -p test
            Starting nodes:
                    v_test_node0001 (127.0.0.1)
    
            Starting Vertica on all nodes. Please wait, databases with large catalogs may take a while to initialize.
    
            Node Status: v_test_node0001: (INITIALIZING)
            Node Status: v_test_node0001: (INITIALIZING)
            Node Status: v_test_node0001: (UP)
            Running upgrade hooks
    Database test started successfully
      

    Where the -t option is pointing to the tool is about to be used the -F it forces the start, -d it point to the database name, -p is the password.

  • To stop your database using the admintools command line:
  • [dbadmin@bih001 ~]$ admintools -t stop_db -F -d test -p test
            Issuing shutdown command to database
    Database test stopped successfully
    
      

    Where the -t option is pointing to the tool is about to be used the -F it forces the stop in case any session are still running, -d it point to the database name, -p is the password.