We are following the DR backup procedures to backup DR. The procedure requires creating a dradmin account with ssh/scp passwordless, but we are not allowed to have a passwordless account. Is there any other option?
The Back Up the Data Repository documentation shows how to set up and run a remote backup of the Data Repository database. The documented steps to Create a Data Repository Backup result in a new dradmin user on the remote hosts and passwordless SSH communication from Data Repository database cluster to the remote backup host(s).
The Vertica 10.x documentation also states the same requirement. In the Vertica Configuring Back Hosts and Connections documentation it states:
For vbr
to access a backup host, the database superuser must meet two requirements:
How you fulfill these requirements depends on your platform and infrastructure.
Are there other backup options if passwordless SSH is not allowed in the environment?
All supported DX NetOps Performance Management releases
Environment doesn't allow passwordless SSH for the dradmin user.
There are only two options to generate the backups. Using Remote or Local backups.
If the required passwordless SSH for dradmin user is not allowed in the environment, an exception would need to be made or the local backup method would be needed.
Local Backups work with existing installs of Vertica, using the existing dradmin user for node to node communications. No additional server to server communications are needed to set up and run a local backup.
To set up Local Backups follow these steps to Configure the Data Repository Host for a Local Backup.
Ideally we'd recommend that after the local backups run, the data stored is copied to a remote server and disk.
When doing so be sure: