Changing an AWS RDS MySQL instance to Postgres

Question

What is the best way to go about this? I have a mobile app a project team developed whereby they setup the database as a MySQL instance. However, with this new project I have with my own developers, we believe Postgres would better suit or needs - but I want everything on one DB instance (data between the mobile app and the new project will be shared). What is the best way to accomplish this?

Chris Williams · Accepted Answer · 2020-06-02 14:45:04Z

3

You will need to create a new RDS instance to switch the engine type to Postgres.

Whilst transitioning you will need to have both running, to migrate the DB across you will want to keep the data synchronised between both. Luckily AWS has the database migration service.

You should try to migrate your existing application to use this first, then remove the DMS setup and shutdown the MySQL database.

answered Jun 2, 2020 at 14:45

Chris Williams

35.7k4 gold badges46 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Changing an AWS RDS MySQL instance to 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