Trying to backup the vertica repository but getting an error

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Need to add a new node to the repository and the first step is to do a backup.

Getting a permissions error when running the init task

$ /opt/vertica/bin/vbr.py --task backup --config-file backup_restore_full_local.ini

 

Error: Error in VBR config: Password file [/opt/vertica/config/password.txt] is not read/write protected. It should be only readable/writable by admin user/group.

Backup FAILED.

Environment

All supported releases

Cause

The file used to store the password for backups has to be accessible only by the dbadmin user and the verticadba group

or the user and group for the user actually running the backup.

Resolution

to set the correct permissions, as the file owner, or root, run

chmod 770 password.txt

(your file name may vary)

Additional Information