CODEWITHSUNDEEP
postgresqlamazon-web-servicesamazon-rdsamazon-aurora
Stan Luo
Stan Luo

Reputation: 3889

AWS: how to downgrade rds engine type from Aurora to Postgres?

The RDS is currently Aurora and I'm thinking of changing to Postgres and use a smaller instance type to save some cost. Downtime is accepted.

Can't seem to do this from the web console, guess I'll have to first create a snapshot, delete the db, and create a new db of postgres type, from the snapshot?

Apologies if the above steps sound weird and I'm open to suggestions. Thanks!

Upvotes: 2

Views: 4467

Answers (1)

Mark B
Mark B

Reputation: 200562

I don't think this is possible to do with snapshots. You will have to perform a pg_dump of the current database, and then load it into the RDS instance using pg_restore.

Upvotes: 2

Related Questions