PostreSQL

PostgreSQL database S3 Management

Why use S3 for Imports/Exports?

Using S3 allows traffic to flow directly from the RDS instance (where the db runs) to S3 (where the data is stored) without needing to move through the GSA network. This allows data to move much faster and avoid taxing GSA bandwidth for heavy data migration efforts.

Setup

Submit a JSM ticket to get an S3 bucket created for the purpose of holding the database backups. An IAM role will also be created and attached to your db so that it can reach the bucket.

Export/backup data to S3

Follow the directions in https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-s3-export.html#postgresql-s3-export-examples to perform an export.

Import/restore data from S3

Follow the directions in https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html#USER_PostgreSQL.S3Import.FileFormats to perform an import.