How to create a Full HP Vertica database backup

We will see how we can create full backup routine for a single node Vertica database. The vbr.py utility uses a configuration file for the information required to back up and restore a full or object-level backup, or to copy a cluster. You cannot run vbr.py without a configuration file, since no default file exists.

  • How to create a backup configuration file using the vbr.py backup tool.
[dbadmin@bih001 ~]$ vbr.py --setupconfig

Snapshot name (backup_snapshot): Full
Backup vertica configurations? (n) [y/n]: y
Number of restore points (1): 1
Specify objects (no default):
Vertica user name (dbadmin):
Save password to avoid runtime prompt? (n) [y/n]: y
Password to save in vbr config file (no default):
Node v_test_node0001
Backup host name (no default): bih001
Backup directory (no default): /tmp
Config file name (Full.ini):
Change advanced settings? (n) [y/n]: n
Saved vbr configuration to Full.ini.
Where are the parameters :
  • Snapshot name
Choose a name that clearly identifies the backup. The name is used in the directory tree structure that vbr.py creates for each node. You do not need to add dates to the backup name, since date and time indicators are added automatically in backup subdirectories.
  • Backup vertica configurations
this include a copy of the vertica.conf file in the backup. The file is not saved by default.
  • Number of restore points
Saving multiple restore points gives you the option to recover from one of several backups.
  • Specify objects
Indicate whether you want to create a full- or object-level backup.
  • Vertica user name
user name of who will invoke vbr.py.
  • Save password to avoid runtime prompt?
Specify whether vbr.py will prompt for an account password at runtime
  • Backup Host and Directory
backup host, and backup directory location.
  • Config file name
the name of your backup generated file.
  • After we have generated our backup configuration file you can run the vbr.py tool.
[dbadmin@bih001 ~]$ vbr.py -t backup --config-file Full.ini

Preparing...
Found Database port:  5433
Copying...
[==================================================] 100%
All child processes terminated successfully.
Committing changes on all backup sites...
backup done!
Where -t will represent the task is about to do and the --config-file points out to the create configuration file. This commnad will generate a full Vertica Database backup without having to stop the databse.
  • This is how a backup configuration file looks like.
[dbadmin@bih001 ~]$ cat Full.ini
[Misc]
snapshotName = Full
verticaConfig = True
restorePointLimit = 1

[Database]
dbName = test
dbUser = dbadmin
dbPassword = test

[Transmission]

[Mapping]
v_test_node0001 = bih001:/tmp

Copyright 2020. All Rights Reserved