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.