Password Configuration File

For improved security, you can store passwords in a separate configuration file and then restrict read access to that file. Set the passwordFile parameter in your vbr configuration file to point to this file. See [Misc] Miscellaneous Settings.

The following is an example of a password file:

[Passwords]
# vertica superuser password for connecting to the database (not the Linux OS password).
dbPassword=myDBsecret

# this goes with [Transmission]serviceAccessUser for connections to remote rsync
serviceAccessPass=myrsyncpw

[Passwords] Password Settings

Parameter Default Description

dbPassword

None

The database administrator's password, and used if dbPromptForPassword is False.
serviceAccessPass None The password for the rsync user account.
dest_dbPassword None

The password for the dest_dbuser Vertica account, for replication tasks only.