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



  • 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 https://www.youtube.com/watch?v=lyNGeDg6EII on youtube to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html , 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?



  • 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/




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2