error persisting data to S3

Hi Colin,

Please make sure you set AWSRegion configuration parameter to the same region as your bucket.

select set_config_parameter('AWSRegion', '[your region]');

dbadmin=> select get_config_parameter('AWSRegion');

get_config_parameter

us-east-1
select set_config_parameter('AWSRegion', 'us-east-2');

set_config_parameter

Parameter set successfully
and bingo .... now it works !

Thanks!

Hi Colin,
Here is some good AWS documentation on the subject: http://docs.aws.amazon.com/AmazonS3/latest/dev/UsingBucket.html
It looks as though you can add the region in the front-end of the URL notation.
Dave

It seems to me that auto-created vertica database has AWSRegion parameter set to us-east-1 even though on the MC cluster creation page is set to us-east-2 . I can see this on a new cluster, so perhaps this needs to be correctly set during cluster provisioning.

+1, same for me. The V node is created in a US region.
For me select set_config_parameter('AWSRegion', 'eu-west-1');
solved this.
Maybe the installation procedure can use the AWS region of the S3 bucket automatically?
Dieter

Dieter, Colin, in addition to fixing the regional issues in a hot fix shortly after 9.0.1, the MC provisioning process will validate the region to avoid this incompatibility.