Vertica Backup

naresh_way2

Hi,
I installed vertica on single node. Now I want to add one more node. For that I need to do backup,but back up fails for me with returning with this error.

$:vbr -t init -c /opt/vertica/config/vbr.ini'
Error: Unable to connect to backup host via password-less SSH: xxx.xx.xxx.32.
Init FAILED.

How do I resolve this error?
Please provide me solution.
Thanks in advance.

kamil

Do you have installed ssh client on your db host machine ?

Can you provide vbr.ini ?

naresh_way2

[Misc]
snapshotName = fullbak
restorePointLimit = 1
objectRestoreMode = createOrReplace
passwordFile = /opt/vertica/config/pwdfile

[Database]
dbName = db_testing_0
dbUser = user_testing

[Transmission]

[Mapping]
v_db_testing_0_node0001 = xxx.xx.xxx.32:/home/user_testing/backup

This is my vbr.ini
Iam getting error while initializing the locations?
I don't have write permission for this user_testing. Do I need that permission If I have to edit anything please provide me.
Thanks in advance.

naresh_way2

Yes I have installed ssh on my db host.

kamil

For sure you need to have RW to directory where backup suppose to be stored...

jheffner

Try running the vbr init task again with --debug 3 and examine the log file under /tmp/vbr/. It will contain the exact ssh command used and possibly more details on the error.