Migrate from aws rds aurora(postgres engine) to regular rds postgres

Question

Due to high i/o cost we want to migrate from aurora(Postgres engine) to Postgres. Is there any way to do this. If no is rebuilding the entire dataset is the only option?

You can use DMS: aws.amazon.com/dms

jordanm
– jordanm

2021-07-04 16:55:12 +00:00
Commented Jul 4, 2021 at 16:55 — jordanm
– jordanm, Commented Jul 4, 2021 at 16:55

Shivam · Accepted Answer · 2021-07-10 23:53:08Z

4

There are a couple of options you can look into for this migration:

Use AWS Database Migration Service to use Aurora PostgreSQL as source, and Postgres(RDS or any other) as target. Refer to the documentation to check on version support and configurations. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.RDSPostgreSQL
Test setting up logical replication from Aurora PostgreSQL to move data changes. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Replication.Logical.html

If the above options are unsuccessful, you can try to re-build with a native dump and restore which could be a more time taking process.

answered Jul 10, 2021 at 23:53

Shivam

2311 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Migrate from aws rds aurora(postgres engine) to regular rds postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related