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?
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
Contenus pertinents
- demandé il y a 3 mois
- Réponse acceptéedemandé il y a un an
AWS OFFICIELA mis à jour il y a 2 ans- AWS OFFICIELA mis à jour il y a 2 ans
- Pourquoi ai-je reçu une erreur en lecture seule après la défaillance d'un cluster DB Amazon Aurora ?AWS OFFICIELA mis à jour il y a 3 ans
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