Password Configuration File Reference

The vbr utility automatically creates the password configuration file to store any saved passwords. Only the database administrator or members of that user's permission group can view the contents of the file. If you alter the file permissions from their default values (xx0), Vertica backup or restore actions fail with an error message.

Vertica creates the password file, even if you do not save any passwords.  In this case, the file exists but remains empty. Vertica stores this file in the same location that you choose to save your backup and restore configuration file.

[Passwords] Password Settings

Parameter Default Description

dbPassword

None

Identifies the database administrator's password. If you set dbPromptForPassword to False, enter a password. Doing so prevents you from being prompted at run time. You do not need to specify additional settings.

Empty strings:

You cannot enter an empty string for the dbPassword in the configuration file. Open Text Corporation does not recommend using an empty string as a superuser password. If you do so, you must:

  1. Set the dbPromptForPassword parameter to True.
  2. Leave the dbPassword option blank.
  3. Enter the empty string at the prompt each time you run the backup utility.
serviceAccessPass None Identifies the password for the rsync user account.
dest_dbPassword None The password for the dest_dbuser Vertica account. Vertica uses this value for replication tasks only.