Backup/Restore an Enterprise Mode or Eon Mode Database to Cloud Storage (backup_restore_cloud_storage.ini)
You must back up Eon Mode databases to a supported cloud storage location. Configuration settings in the [CloudStorage] section are identical for both Enterprise Mode and Eon Mode.
There are one-time configurations that you must complete before your first backup to a new cloud storage location. See Additional Considerations for Cloud Storage for more information.
Backups to on-premises cloud storage destinations require additional configuration for both Enterprise Mode and Eon databases. See the "Backing Up an On-Premises Database" section in Configuring Backups to and from Cloud Storage for information about the additional requirements. Other communal storage locations, such as HDFS, cannot be backed up or restored using vbr.
To restore, use the same configuration file that you used to create the backup. To restore selected objects rather than the entire database, specify the objects to restore on the vbr command line using --restore-objects.
; This sample vbr configuration file shows backup to Cloud Storage e.g AWS S3, GCS or on-premises (e.g. Pure Storage) ; This can be used for Vertica databases in Enterprise or Eon mode. ; Section headings are enclosed by square brackets. ; Comments have leading semicolons (;) or pound signs (#). ; Option and values are separated by an equal sign. ; Only arguments marked as '!!Mandatory!!' must be specified explicitly. ; All commented parameters are set to their default value. ; ------------------------------------------- ; ;;; BASIC PARAMETERS ;;; ; ------------------------------------------- ; [CloudStorage] ; This section replaces the [Mapping] section and is required to back up to cloud storage. ; !!Mandatory!! S3 or GS bucket name(no default). cloud_storage_backup_path = gs://backup_bucket/database_backup_path/ ; cloud_storage_backup_path = s3://backup_bucket/database_backup_path/ ; !!Mandatory!! directory used to manage locking during a backup (no default). If the directory is mounted on the initiator host, you ; should use "[]" instead of the local host name. The file system must support POSIX fcntl flock. cloud_storage_backup_file_system_path = []:/home/dbadmin/backup_locks_dir/ [Misc] ; !!Recommended!! Snapshot name ; 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 values: a-z A-Z 0-9 - _ ; snapshotName = backup_snapshot ; Specifies how Vertica handles objects of the same name when restoring schema or table backups. ; objectRestoreMode = createOrReplace ; Specifies which tables and/or schemas to copy. For tables, the containing schema defaults to public. ; Note: 'objects' is incompatible with 'includeObjects' and 'excludeObjects'. ; (no default) ; objects = mytable, myschema, myothertable ; Specifies the set of objects to backup/restore; wildcards may be used. ; Note: 'includeObjects' is incompatible with 'objects'. ; includeObjects = public.mytable, customer*, s? ; Subtracts from the set of objects to backup/restore; wildcards may be used ; Note: 'excludeObjects' is incompatible with 'objects'. ; excludeObjects = public.*temp, etl.phase? [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 ;;; ; ------------------------------------------- ; [CloudStorage] ; Specifies encryption-at-rest on S3 ; cloud_storage_encrypt_at_rest = sse ; cloud_storage_sse_kms_key_id = <key_id> ; Specifies SSL encrypted transfer. ; cloud_storage_encrypt_transport = True ; Specifies the number of threads for upload/download - backup ; cloud_storage_concurrency_backup = 10 ; Specifies the number of threads for upload/download - restore ; cloud_storage_concurrency_restore = 10 ; Specifies the number of threads for deleting objects from the backup location ; cloud_storage_concurrency_delete = 10 ; Specifies the path to a custom SSL server certificate bundle ; cloud_storage_ca_bundle = /home/user/ssl_folder/ca_bundle.pem [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 ; 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 [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