Update RDS Aurora Postgres from 13.4 to 14.4

0

Hi,

I have 13.4 db with app working fine. How can I test it on 14.4? What AWS recommends? Should I create another cluster 14.4 and test it with this version?

2 Answers
2
Accepted Answer

HI, For RDS Aurora Postgres, the simplest way will be to use the restore cluster from snapshot method.

In this method you can create a snapshot of the cluster and once the snapshot is in Available state, go to the snapshot section in RDS console and select the snapshot which you just created. Then in the actions list, select restore snapshot. There you can see the available engine versions which you can select to upgrade the cluster. Please note that you can only update to the engine version which is listed. Once selected, new cluster with the new engine version will be created.

There are different methods as well, you can refer the following links for more information and different methods

https://aws.amazon.com/blogs/database/part-1-upgrade-your-amazon-rds-for-postgresql-database-comparing-upgrade-approaches/ https://aws.amazon.com/blogs/database/part-2-upgrade-your-amazon-rds-for-postgresql-database-using-the-pglogical-extension/ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-restore-snapshot.html

AWS
answered a year ago
  • Yes. This would be a preferred way! However, you may need to specify a parameter group specific to your new engine version.

    To resolve this, simply try to create a new parameter group with the new version and select the old and new one to compare (there is a compare option). In this way, you can see what needs to be changed or updated easily

0

Hello,

It is recommended to create another cluster with the required version and test it with your application.

AWS
answered a year 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