How to setup restart policy of our Vertica database using the admintools command line

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

  • How to setup restart policy of our Vertica database using the admintools command line:
  • For this task you need to use the set_restart_policy

    [dbadmin@bih001 ~]$ admintools -t set_restart_policy -d test --policy always
    Setting DB test restart policy to always and replicating to cluster...
    Database test policy set to always
    Where the -d option is followed by the database name, --policy can receive ('never', 'ksafe', 'always').
  • Never — Nodes are never restarted automatically.
  • K-Safe — Nodes are automatically restarted if the database cluster is still UP. This is the default setting.
  • Always - Node on a single node database is restarted automatically.