Import and Export to S3 from Amazon Aurora with PostgreSQL compatibility subfolder gotcha

UPDATE – I was prefacing the file with a forward slash… once removed it works fine!

SELECT aws_commons.create_s3_uri( ‘aurora-pg-sample-loaddata’, ‘testfolder/Final/apg2s3_tableFinal’,’eu-central-1′) AS s3_uri_1 \gset

This is a pretty cool feature!

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html

One gotcha though! It looks like you can only import from the root of an S3 bucket!

https://stackoverflow.com/questions/58616005/import-postgres-data-into-rds-using-s3-and-aws-s3

It just throws a permission error

ERROR: HTTP 403. Permission denied. Check bucket or provided credentials as they may no longer be valid.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s