search cancel

Setup of Vertica backup

book

Article ID: 145379

calendar_today

Updated On:

Products

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

Issue/Introduction

How to setup 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

The following is an example backup.

The password file is:

[[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

You can set the password for the dradmin Vertica user in it as:

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

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

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

[[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!


Output Results can be viewed as follows:

[[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

Additional Information

TechDocs : DX NetOps 21.2 : Configure the Data Repository Host for a Local Backup