We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


backup fail:Cannot find the password file — Vertica Forum

backup fail:Cannot find the password file

Yesterday, I wanted to backup the full database  under vertica-7.1.1community version.

I did what the guid said, using vbr.py --setupconfig  command step by step.image

Both of the db.ini,pwd file  was under the "/home/vertica" directory.

The content of the db.ini was as below:

**************************************************************************
[Misc]snapshotName = db
restorePointLimit = 1
passwordFile = pwd

[Database]
dbName = db_vertica_test
dbUser = vertica

[Transmission]

[Mapping]
v_db_vertica_test_node0001 = vertica01:/home/vertica/backup
v_db_vertica_test_node0002 = vertica02:/home/vertica/backup

**************************************************************************




The content of the pwd file was as below:

**************************************************************************
dbPassword = vertica
**************************************************************************


Then , run the command "/opt/vertica/bin/vbr.py --task backup --config-file db.ini":

image

It's my pleasure to get your help to know why this error occurred and the solution. 

Comments

  • Hello Zhoumo, can you give the absolute path for the password file location and then try?

    passwordFile = /home/vertica/pwd
  • Thank for your answer。 

    The problem was solved when I copied the pwd file to another node.
  • Thank for your answer。 

    The problem was solved when I copied the pwd file to another node.
  • hi zhoumo, did you have to put the pwd file on all of your nodes? i would have assumed that just putting it on the primary master node would have been enough. I'm curious to know how you solved this issue.
  • Hi Anthony,

    Check the .ini file , if full path is not there please add

    passwordFile = <full path>

    e.g
    passwordFile=/home/vertica/pwd_quantros

    Also copy the pwd file to other nodes.

    Regards

    Bhawana

  • Also copy the Password file to the remote backup host if your using one.

Leave a Comment

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