Postgres upgradation - Mailing list pgsql-admin

From Narendran .j
Subject Postgres upgradation
Date
Msg-id CA+-Cqf4EoAxwfqvUQiPU--zJ2Qt+wA3239XWE13gKD+PGqZa+Q@mail.gmail.com
Whole thread Raw
Responses Re: Postgres upgradation
List pgsql-admin
Hello All,

In our environment, PostgreSQL is currently running on lower versions, ranging from 9 to 11. We are planning to upgrade to the latest version, and I have a few questions regarding the process.

What are the key considerations or checks we need to perform before the upgrade?

Can we directly upgrade from version 9 to 15, or is a step-by-step upgrade required?

How should we handle extensions during the upgrade process?

What challenges or issues should we anticipate during or after the upgrade?

If anyone with experience in upgrading Postgres, please share your guidance.

Regards,
Naren

pgsql-admin by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Postgres DB crashing in OpenSSL 3.2 Version
Next
From: lakshmi sravya
Date:
Subject: Re: Dead tuple ratio for table & index