3

Amazon RDS Postgres database are backed up as snapshots automatically. Because of the high storage costs ($0.095 per GB-Month), I want to move them to S3 (Storage Class: Glacier Deep Archive: 0.00099 per GB-Month).

I basically followed this excellent guide on youtube to export DB snapshot data to Amazon S3, which creates a file structure with parquet files per table.

Before I proceed, I want to make sure I'm able to restore those files in S3 as a new database instance again. I can't find options to do that within AWS. So my question is this.

How to restore a RDS Postgres instance from a snapshot exported to S3?

Improve this question

2 Answers 2

Reset to default
1

I found this resource on aws for importing for Postgres from s3. Though it does not exactly restore. We have to do the work to restore. Importing Amazon S3 data into an RDS for PostgreSQL DB instance

I wish it had something like it has for MySQL DB. You can restore the MySQL db instance itself. restore-db-instance-from-s3

Improve this answer
1
  • Thank you. However they don't mention how the data on S3 should look like. Do they mean restoring whatever a pg_dump generated (either custom format or sql) or do they mean an RDS snapshot copied to S3?
    – Christiaan Westerbeek
    Commented Jun 16, 2022 at 9:46
0

I'm still waiting for AWS to provide a full PG RDS restore from snapshot stored on S3.

at the moment this is the closest thing you can do, per table basis only. https://aws.amazon.com/about-aws/whats-new/2019/04/amazon-rds-postgresql-supports-data-import-from-amazon-s3/

Improve this answer
2
  • Hi! Also was looking for the restore options from AWS. Have you found any better solution?
    – Azamat Ahunjanov
    Commented May 19, 2022 at 7:21
  • Also waiting for the same, similarly frustrated by AWS seemingly implying this would be like extra-cold storage for backups... anyway, in that YouTube video guide you watched, at around 4:30 it shows how to use Glue & Athena to query the parquet files in the "snapshot-export" on S3. It's not a solution, but it's a workaround in some cases, just FYI in case that would help you.
    – TCAllen07
    Commented Jun 1, 2022 at 16:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.