Re: Upgrade from 12.22 to 16

On Wed, 2025-06-11 at 12:23 +0530, Wasim Devale wrote:
> > Please suggest me to upgrade postgresql: 400 GB data with minimal downtime apart
> > from in place upgrade. We have it on red hat 9.
>
> I mean to say that we do not want to do the in place upgrade also the other option
> of taking dump and restoration of it. If I can have any robust plan who all have
> worked on that then please suggest me.

"I want to upgrade with minimal downtime, but I don't want the natural, simple
 solution for upgrade with minimal downtime."

Strange requirement, but if you feel you want to make your life more difficult, you
can use logical replication for an upgrade with very short downtime.

Yours,
Laurenz Albe