RE: Upgrade from 12.22 to 16

You can use logical replication if new version of your postgres is on other host.

Best regards!
[izum]
Domen Šetar
Computer Systems Support
IZUM – Institute of Information Science | Prešernova ulica 17 | 2000 Maribor | Slovenia
T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si<http://www.izum.si/> | domen(dot)setar(at)izum(dot)si<mailto:domen(dot)setar(at)izum(dot)si>

From: Wasim Devale <wasimd60(at)gmail(dot)com>
Sent: Wednesday, June 11, 2025 8:54 AM
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Upgrade from 12.22 to 16

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.

Thanks,
Wasim

---------- Forwarded message ---------
From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at<mailto:laurenz(dot)albe(at)cybertec(dot)at>>
Date: Wed, 11 Jun, 2025, 12:13 pm
Subject: Re: Upgrade from 12.22 to 16
To: Wasim Devale <wasimd60(at)gmail(dot)com<mailto:wasimd60(at)gmail(dot)com>>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>>

On Wed, 2025-06-11 at 11:51 +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.

What do you mean with "apart from"?

Yours,
Laurenz Albe