ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Vertica backup

book

Article ID: 145379

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Customer needs help setting up the vertica backup

Cause

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.

Environment

Dx NetOps Performance Management 21.2.x

Resolution

Here are the backup example:

[[email protected] example_configs]# ls -al /opt/vertica/config/password.txt
-rw------- 1 dradmin verticadba 33 Feb 18 14:09 /opt/vertica/config/password.txt
[[email protected] example_configs]#

[[email protected] example_configs]# cat /opt/vertica/config/password.txt
[Passwords]
dbPassword = dbpass
[[email protected]_configs]#


backup_restore_full_local.ini file:
v_drdata_node0001 = []:/export/dradmin/backups
snapshotName = backup_snapshot
dbName = drdata
tempDir = /tmp/vbr
restorePointLimit = 1
passwordFile = /opt/vertica/config/password.txt
dbUser = dradmin


Commands:
[[email protected] /] $ /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.

[[email protected] /] $ /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!
[[email protected] /]$


Results:
[[email protected] 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
[[email protected] example_configs]#

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/21-2/administrating/data-repository-administration/configure-the-data-repository-host-for-a-local-backup.html