Thread: Upgrade PG from 12 to latest
Hello Folks,
We are running PG 12 on AWS RDS. I want to run an upgrade process for the DB. The org I work for attempted to upgrade before but failed (12->15). The upgrade resulted in unexplained slowness, and performance issues were only resolved via a downgrade. Do you have any upgrade docs or recommendations you can share about the upgrade process before I try to go on the journey?
Thank you,
-Doron
Hi Doron Tsur,
Could you please look into
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html
https://aws.amazon.com/blogs/database/best-practices-for-upgrading-amazon-rds-to-major-and-minor-versions-of-postgresql/
https://aws.amazon.com/blogs/database/best-practices-for-upgrading-amazon-rds-to-major-and-minor-versions-of-postgresql/
Best of luck :)
Regards,
Muhammad Ikram
Bitnine Global.
On Sun, Jun 23, 2024 at 12:09 PM Doron Tsur <qballer@gmail.com> wrote:
Hello Folks,We are running PG 12 on AWS RDS. I want to run an upgrade process for the DB. The org I work for attempted to upgrade before but failed (12->15). The upgrade resulted in unexplained slowness, and performance issues were only resolved via a downgrade. Do you have any upgrade docs or recommendations you can share about the upgrade process before I try to go on the journey?Thank you,-Doron
--
Muhammad Ikram
On Sun, 2024-06-23 at 10:08 +0300, Doron Tsur wrote: > We are running PG 12 on AWS RDS. I want to run an upgrade process for the DB. > The org I work for attempted to upgrade before but failed (12->15). The upgrade > resulted in unexplained slowness, and performance issues were only resolved via > a downgrade. We cannot provide help for Amazon's upgrade process. If you still have the slow database, you should analyze what exactly was slow and why. Yours, Laurenz Albe