Vertica Analytics Platform Version 9.2.x Documentation

[Database] Database Access Settings

Sets options for accessing the database.

Parameter Default Description

dbName

N/A

Specifies the name of the database to back up. If you do not supply a database name, vbr selects the current database to back up.

Micro Focus recommends that you provide a database name.

dbUser

Current user name

Identifies the Vertica user used for database operations performed by vbr. In the case of the replicate task, this user is the source database user. You must be logged on as the database administrator to back up the database. The password, if you choose to save it, is stored in the Password Configuration File.

dbPromptForPassword

True

Controls whether vbr prompts for a password. If you set this parameter to False (indicating no prompt at runtime), then you must also set the database administrator password in the dbPassword parameter. If you do not supply a password in the configuration file, vbr prompts for one at runtime.

vbr uses destination database parameters only to replicate objects to alternate clusters.

Parameter Default Description
dest_dbName N/A Specifies the name of the destination database.
dest_dbUser N/A Identifies the Vertica user name in the destination database to be used for loading the replicated data. This user must have default superuser privileges.
dest_dbPromptForPassword N/A Controls whether vbr prompts for a password for the destination database. If you set this parameter to False (indicating no prompt at runtime), then you must also enter the destination database administrator password in the dest_dbPassword parameter. If you do not supply a password in the configuration file, vbr prompts for one at runtime.