External Full Backup/Restore (backup_restore_full_external.ini)
An external (distributed) backup backs up each database node to a distinct backup host. Nodes are mapped to hosts in the [Mapping] section.
To restore, use the same configuration file that you used to create the backup.
; This sample vbr configuration file shows full or object backup and restore to a separate remote backup-host for each respective database host. ; Section headings are enclosed by square brackets. ; Comments have leading semicolons (;) or pound signs (#). ; An equal sign separates options and values. ; Specify arguments marked '!!Mandatory!!' explicitly. ; All commented parameters are set to their default value. ; ------------------------------------------- ; ;;; BASIC PARAMETERS ;;; ; ------------------------------------------- ; [Mapping] ; !!Mandatory!! This section defines what host and directory will store the backup for each node. ; node_name = backup_host:backup_dir ; In this "parallel backup" configuration, each node backs up to a distinct external host. ; To backup all database nodes to a single external host, use that single hostname/IP address in each entry below. v_exampledb_node0001 = 10.20.100.156:/home/dbadmin/backups v_exampledb_node0002 = 10.20.100.157:/home/dbadmin/backups v_exampledb_node0003 = 10.20.100.158:/home/dbadmin/backups v_exampledb_node0004 = 10.20.100.159:/home/dbadmin/backups [Misc] ; !!Recommended!! Snapshot name. Object and full backups should always have different snapshot names. ; Backups with the same snapshotName form a time sequence limited by restorePointLimit. ; SnapshotName is used for naming archives in the backup directory, and for monitoring and troubleshooting. ; Valid characters: a-z A-Z 0-9 - _ ; snapshotName = backup_snapshot [Database] ; !!Recommended!! If you have more than one database defined on this Vertica cluster, use this parameter to specify which database to backup/restore. ; dbName = current_database ; If this parameter is True, vbr prompts the user for the database password every time. ; If False, specify the location of password config file in 'passwordFile' parameter in [Misc] section. ; dbPromptForPassword = True ; ------------------------------------------- ; ;;; ADVANCED PARAMETERS ;;; ; ------------------------------------------- ; [Misc] ; The temp directory location on all database hosts. ; The directory must be readable and writeable by the dbadmin, and must implement POSIX style fcntl lockf locking. ; tempDir = /tmp/vbr ; How many times to retry operations if some error occurs. ; retryCount = 2 ; Specifies the number of seconds to wait between backup retry attempts, if a failure occurs. ; retryDelay = 1 ; Specifies the number of historical backups to retain in addition to the most recent backup. ; 1 current + n historical backups ; restorePointLimit = 1 ; Full path to the password configuration file ; Store this file in directory readable only by the dbadmin ; (no default) ; passwordFile = /path/to/vbr/pw.txt ; When enabled, Vertica confirms that the specified backup locations contain ; sufficient free space and inodes to allow a successful backup. If a backup ; location has insufficient resources, Vertica displays an error message explaining the shortage and ; cancels the backup. If Vertica cannot determine the amount of available space ; or number of inodes in the backupDir, it displays a warning and continues ; with the backup. ; enableFreeSpaceCheck = True ; When performing a backup, replication, or copycluster, specifies the maximum ; acceptable difference, in seconds, between the current epoch and the backup epoch. ; If the time between the current epoch and the backup epoch exceeds the value ; specified in this parameter, Vertica displays an error message. ; SnapshotEpochLagFailureThreshold = 3600 [Transmission] ; Specifies the default port number for the rsync protocol. ; port_rsync = 50000 ; Total bandwidth limit for all backup connections in KBPS, 0 for unlimited. Vertica distributes ; this bandwidth evenly among the number of connections set in concurrency_backup. ; total_bwlimit_backup = 0 ; The maximum number of backup TCP rsync connection threads per node. ; Optimum settings depend on your particular environment. ; For best performance, experiment with values between 2 and 16. ; concurrency_backup = 1 ; The total bandwidth limit for all restore connections in KBPS, 0 for unlimited ; total_bwlimit_restore = 0 ; The maximum number of restore TCP rsync connection threads per node. ; Optimum settings depend on your particular environment. ; For best performance, experiment with values between 2 and 16. ; concurrency_restore = 1 [Database] ; Vertica user name for vbr to connect to the database. ; This setting is rarely needed since dbUser is normally identical to the database administrator ; dbUser = current_username