Upgrade PG from 12 to latest

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/

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