Migrating Aurora Postgres to RDS Postgres


Hi there, Is there a way to Migrate an Aurora-based Postgres Db to an RDS Postgres Instance? I have searched on AWS docs I couldn't find any. Any Pointer will be greatly appreciated. Thanks

1 Answer

Kindly note that there is no direct method to convert/migrate from Aurora PostgreSQL to RDS PostgreSQL. However, as a work-around, I have shared a couple of alternatives that you could review further.

  1. Using PostgreSQL native tools such as pg_dump and pg_restore. A) Since Aurora PostgreSQL and PostgreSQL have the same underlying engine, using the engine's native tools is usually the best way to perform migrations. Take the pg_dump from Aurora PostgreSQL and restore the dump into the newly created RDS instance. Please follow the link [1] below for detailed steps: I) Create a dump using pg_dump that contains the data to be loaded[2]. II) Create the target RDS DB instance III) Use psql to create the database on the DB instance and load the data or use pg_restore IV) Create a DB snapshot of the RDS DB instance

  2. Using AWS Database Migration Service (AWS DMS)[3]. A) AWS DMS is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores.

B) With AWS DMS, we can perform one-time migrations (full-load), and you can replicate ongoing changes to keep sources and targets in sync[4]. AWS DMS provides minimum downtime, but the setup can be complex and might need a learning curve.

C) With that said, there are also some limitations on using PostgreSQL as source and target endpoint, as specified in Document links [5-8].

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html

[2] https://www.postgresql.org/docs/8.3/backup.html

[3] http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.html

[4] http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Components.html

[5] http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html

[6] http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Reference.Source.PostgreSQL.DataTypes.html

[7] http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.PostgreSQL.html

[8] http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Reference.Target.PostgreSQL.DataTypes.html

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions