set restart policy at database creation using adminTools

Moderator: NorbertKrupa

Post Reply
menita
Newbie
Newbie
Posts: 2
Joined: Wed Jul 17, 2013 7:48 pm

set restart policy at database creation using adminTools

Post by menita » Wed Jul 17, 2013 9:51 pm

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

User avatar
BoMBaY
Beginner
Beginner
Posts: 26
Joined: Tue Jul 16, 2013 5:45 am

Re: set restart policy at database creation using adminTools

Post by BoMBaY » Thu Jul 18, 2013 8:21 am

Which version of Vertica you are using ? Can you try the commands below.

Code: Select all

/opt/vertica/bin/admintools -t set_restart_policy -d DB -p 'always'
and

Code: Select all

/opt/vertica/bin/admintools -t set_restart_policy -d DB -p always
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)

Image
ImageImage

menita
Newbie
Newbie
Posts: 2
Joined: Wed Jul 17, 2013 7:48 pm

Re: set restart policy at database creation using adminTools

Post by menita » Fri Jul 19, 2013 9:52 pm

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

User avatar
BoMBaY
Beginner
Beginner
Posts: 26
Joined: Tue Jul 16, 2013 5:45 am

Re: set restart policy at database creation using adminTools

Post by BoMBaY » Fri Jul 26, 2013 8:11 am

Could you please capture the screen. The error doesn't make sense.
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)

Image
ImageImage

raj
Newbie
Newbie
Posts: 1
Joined: Fri Jul 26, 2013 2:06 pm

Re: set restart policy at database creation using adminTools

Post by raj » Fri Jul 26, 2013 3:26 pm

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.

Post Reply

Return to “New to Vertica”