Sets options for storing backup data on Amazon S3.

Note: The [S3] and [Mapping] configuration sections are mutually exclusive. If you include both, your backup fails with the error message "Config has conflicting sections (Mapping, S3), specify only one of them."

Parameter Default Description



Specifies the host and path that you are using to handle file locking during the backup process. Vertica must be able to create a passwordless ssh connection to the location that you specify here.

To use a local NFS file system, specify a value of:

s3_backup_file_system_path = []:path

To use an EC2 instance, specify a value of:

s3_backup_file_system_path = [host_name]:path



Specifies the S3 bucket name and backup path for the backup to S3. When you backup to S3, all nodes back up to same S3 bucket. You must create the backup location on S3 before performing a backup. This value takes the following form:

s3_backup_path = s3://backup_bucket/database_backup_path/



When True, uses SSL encryption to encrypt data moving between your Vertica cluster and your S3 instance. If you are backing up or restoring from an Amazon EC2 cluster, you must set this parameter to True.

s3_concurrency_backup 10 The maximum number of concurrent backup threads for backup to S3.
s3_concurrency_restore 10 The maximum number of concurrent restore threads for restoring from S3.
s3_encrypt_at_rest None

To enable at rest encryption of your backups to S3, specify a value of sse. For more information on encrypting your S3 backups, refer to Encrypting Backups to S3.

This value takes the following form:

s3_encrypt_at_rest = sse
s3_sse_kms_key_id None

If you are using Amazon's Key Management Security, use this parameter to provide your key ID. If you enable encryption and do not include this parameter, vbr uses SS3-S3 encryption.

This value takes the following form:

s3_sse_kms_key_id = <key_id>


Was this topic helpful?