Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica Backup

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:

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


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

    Can you provide vbr.ini ?

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

    dbName = db_testing_0
    dbUser = user_testing


    v_db_testing_0_node0001 =

    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.

  • Yes I have installed ssh on my db host.

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

  • 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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.