Full Hardlink Backup/Restore (backup_restore_full_hardlink.ini)
Creating hard link local backups requires that you manually add the hardLinkLocal=True
parameter to the [Transmission]
section of the vbr
configuration file.
The backup directory must be in the same file system as the database data directory.
You cannot use the encrypt
parameter when creating a hard link local backup. If you add hardlinkLocal=true
to a configuration file that includes encrypt=true
, vbr
issues a warning and then ignores the encryption parameter.
; This sample vbr configuration file shows backup and restore using hard-links to data files on each database host for that host's backup. ; 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] ; For each database node there must be one [Mapping] entry to indicate the directory to store the backup. ; !!Mandatory!! Backup host name (no default) and Backup directory (no default). ; node_name = backup_host:backup_dir ; Must use [] for hardlink backups v_exampledb_node0001 = []:/home/dbadmin/backups v_exampledb_node0002 = []:/home/dbadmin/backups v_exampledb_node0003 = []:/home/dbadmin/backups v_exampledb_node0004 = []:/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. ; Valid characters: a-z A-Z 0-9 - _ ; snapshotName = backup_snapshot ; 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 [Transmission] ; !!Mandatory!! Identifies the backup as a hardlink style backup. hardLinkLocal = True ; ------------------------------------------- ; ;;; ADVANCED PARAMETERS ;;; ; ------------------------------------------- ; [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 [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 ; Full path to the password configuration file ; Store this file in directory readable only by the dbadmin. ; (no default) ; passwordFile = ; Specifies the number of historical backups to retain in addition to the most recent backup. ; 1 current + n historical backups ; restorePointLimit = 1 ; Specifies the number of backup attempts after an error occurs. ; retryCount = 2 ; Specifies the number of seconds to wait between backup retry attempts if a failure occurs. ; retryDelay = 1 ; 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 [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