How to setup the Vertica backup
Dx NetOps Performance Management all versions
The Vertica backup script will use passwordless ssh as the database admin user (dradmin by default).
Make sure that passwordless ssh is working for that user to all nodes in the cluster.
The following is an example backup.
The password file is:
[root@ example_configs]# ls -al /opt/vertica/config/password.txt
-rw------- 1 dradmin verticadba 33 Feb 18 14:09 /opt/vertica/config/password.txt
You can set the password for the dradmin Vertica user in it as:
[root@ example_configs]# cat /opt/vertica/config/password.txt
[Passwords]
dbPassword = dbpass
The password file is referenced from the backup configuration files. Examples of the backup configuration exist for multiple scenarios and are located under the directory:
[root@ example_configs]# ls -l /opt/vertica/share/vbr/example_configs/backup_restore_*
backup_restore_cloud_storage.ini
backup_restore_full_external.ini
backup_restore_full_hardlink.ini
backup_restore_full_local.ini
backup_restore_object_local.ini
To create a backup to a local partition, use the backup_restore_full_local.ini config file which has the following values:
[root@ example_configs]# cat /opt/vertica/share/vbr/example_configs/backup_restore_full_local.ini
v_drdata_node0001 = []:/export/dradmin/backups
snapshotName = backup_snapshot
dbName = drdata
tempDir = /tmp/vbr
restorePointLimit = 1
passwordFile = /opt/vertica/config/password.txt
dbUser = dradmin
Then run the Vertica backup script Commands using the backup_restore_full_local.ini file as the configuration:
[dradmin@ /] $ /opt/vertica/bin/vbr.py --task init --config-file /opt/vertica/share/vbr/example_configs/backup_restore_full_local.ini
Initializing backup locations.
Backup locations initialized.
[dradmin@l /] $ /opt/vertica/bin/vbr.py --task backup --config-file /opt/vertica/share/vbr/example_configs/backup_restore_full_local.ini
Starting backup of database drdata.
Participating nodes: v_drdata_node0001.
Snapshotting database.
Snapshot complete.
Approximate bytes to copy: 11925616224 of 11925616224 total.
[==================================================] 100%
Copying backup metadata.
Finalizing backup.
Backup complete!
Output Results can be viewed as follows:
[root@ example_configs]# ls -al /export/dradmin/backups/
total 904
drwxr-xr-x 4 dradmin verticadba 88 Feb 18 14:14 .
drwx------ 7 dradmin verticadba 176 Feb 18 13:33 ..
-rw-r--r-- 1 dradmin verticadba 886605 Feb 18 14:14 backup_manifest
-rw-r--r-- 1 dradmin verticadba 2 Feb 18 14:12 .index
-rw------- 1 dradmin verticadba 63 Feb 18 14:12 .lock
drwxr-xr-x 502 dradmin verticadba 12288 Feb 18 14:14 Objects
drwxr-xr-x 3 dradmin verticadba 45 Feb 18 14:14 Snapshots
Back Up the Data Repository guide https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/23-3/administrating/data-repository-administration/back-up-the-data-repository.html
Also see Incremental or repeated backups https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RepeatingBackups.htm?zoom_highlight=restorePointLimit