On Thu, Oct 23, 2025 at 10:51 AM Bala M <[email protected]> wrote:

> Any advice, recommendations, or shared experiences from others who have
> performed similar migrations would be greatly appreciated.


Some related advice: put some system in place to make sure you are always
running the latest revision in whatever major version you end up. See:

https://www.postgresql.org/support/versioning/

In particular, note this part:

*The community considers performing minor upgrades to be less risky than
continuing to run an old minor version.*

You also want to put something in place to make sure your major version
does not  fall so far behind again. You don't need to upgrade every year,
but certainly target a major upgrade every 2-3 years. As you will discover,
the major upgrade process is going to be much easier than this current
upgrade we are talking about in this thread.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

Reply via email to