search

pgspider / dynamodb_fdw

DynamoDB Foreign Data Wrapper for PostgreSQL
Other
31 stars 6 forks source link

how to specify region #8

Open gettes opened 5 months ago

gettes commented 5 months ago

I am finally at a point where i can test against AWS and I am running into a problem where I need to specify the region (not just with something like https://dynamodb.us-west-2.amazonaws.com/). There seems to be no option to specify the region for the table or the server. I am getting errors indicating a problem with credentials -- the creds are in us-east-1 but the dynamodb is us-west-2. How is this to be done?

hrkuma commented 5 months ago

Hello,

As like you said, this FDW does not support region option now. So I think you may need some additional setting in the code if you want to try.

https://github.com/pgspider/dynamodb_fdw/blob/main/connection.cpp#L317

const Aws::String awsRegion = "us-west-2";
clientConfig.region = awsRegion;