Hi,
I am have a single node install of Vertica on localhost. I am creating one database and loading the schema for the database at the time of creation. What is the sytax to set the set_restart_policy to 'always' so that the database restarts automatically on a reboot. i have tried different variation (below) and all ends up in errors
/opt/vertica/bin/adminTools -t create_db -d DBNAME -p 'password' --hosts=127.0.0.1 set_restart_policy --policy='always'
Error
Command line contains unknown options set_restart_policy
Please verify your command line syntax and try again.
OR
/opt/vertica/bin/adminTools -t create_db -d DBNAME -p 'password' --hosts=127.0.0.1 set_restart_policy --policy='always'
/opt/vertica/bin/adminTools -t set_restart_policy -d DBNAME--policy='always'
Error - database already exist.
My problem is that i cant afford to set the restart policy post installtion using the adminTools/MC. It has to be done during db creation or as the next step to creation. Thanks in advance for your timely help.
Menita
set restart policy at database creation using adminTools
Moderator: NorbertKrupa
Re: set restart policy at database creation using adminTools
Which version of Vertica you are using ? Can you try the commands below.
and
Code: Select all
/opt/vertica/bin/admintools -t set_restart_policy -d DB -p 'always'
Code: Select all
/opt/vertica/bin/admintools -t set_restart_policy -d DB -p always
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)
DBA Specialist (Vertica/Oracle)
Re: set restart policy at database creation using adminTools
i tried that and the error i got is
Setting DB <> restart policy to always and replicating to cluster...
ERROR: Unable to set restart policy until cluster is fully reachable.
The following communications failed:
127.0.0.1 from 127.0.0.1
Setting DB <> restart policy to always and replicating to cluster...
ERROR: Unable to set restart policy until cluster is fully reachable.
The following communications failed:
127.0.0.1 from 127.0.0.1
Re: set restart policy at database creation using adminTools
Could you please capture the screen. The error doesn't make sense.
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)
DBA Specialist (Vertica/Oracle)
Re: set restart policy at database creation using adminTools
Just configure passwordless ssh (to localhost) for dbadmin user and you will not see the "ERROR: Unable to set restart policy until cluster is fully reachable." message.