5.6 Shutting Down a Vertica Node

If you need to shut down a Vertica node for maintenance, then ensure that you refer to the following steps to ensure that there is no loss in data:

  1. Login to the Vertica database using the dbadmin user and run the following commands:

    1. select close_all_sessions(); For more information, see the Vertica Documentation.

    2. select make_ahm_now();

    3. select do_tm_task('moveout');

    4. select do_tm_task('mergeout');

    5. select make_ahm_now();

  2. Stop the node using admintools command: admintools -t stop_node -s <HOSTS> where -s <HOSTS> is a comma separated list of hosts on which the Vertica process needs to be stopped.