Update RDS Aurora Postgres from 13.4 to 14.4
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?
- Newest
- Most votes
- Most comments
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
Hello,
It is recommended to create another cluster with the required version and test it with your application.
Relevant content
- Accepted Answerasked 4 months ago
- Accepted Answerasked 2 years ago
- Accepted Answerasked 2 years ago
AWS OFFICIALUpdated 7 months ago- AWS OFFICIALUpdated 2 years 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