Thread: Upgrade PG from 12 to latest

Upgrade PG from 12 to latest

From
Doron Tsur
Date:
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 

Re: Upgrade PG from 12 to latest

From
Muhammad Ikram
Date:

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

Re: Upgrade PG from 12 to latest

From
Laurenz Albe
Date:
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