The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Custom access/secret_key for VBR backups
Hello Vertica gurus and fellow explorers,
I have a V9 EON cluster setup with explicit access/secret_key with RW permissions to the primary db S3 bucket inside the admintools.conf. I was trying to setup a separate key pair and S3 bucket to use for running the backup job, but I cannot find any way to set access/secret_key for VBR tool specifically.
Anyone knows of a way to do this? Maybe some undocumented parameter?
I appreciate your help! 
1
Answers
You can do it by specifying the following in your vbr.ini
AWS credential file - You can manually create a configuration file on your EC2 initiator host at ~/.aws/credentials.
[default]
aws_access_key_id = YOUR_ACCESS_KEY
aws_secret_access_key = YOUR_SECRET_KEY
If you are planning to add encryption, please visit the below link and refer to section "Encrypting Backups"
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/CreatingBackupsonAmazonS3.htm
Thanks @SruthiA ! I'll give it a shot.