RE: Upgrade from 12.22 to 16

[Domen Šetar <domen.setar@xxxxxxx>]

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

 

Best regards!

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 | domen.setar@xxxxxxx

 

 

From: Wasim Devale <wasimd60@xxxxxxxxx>
Sent: Wednesday, June 11, 2025 8:54 AM
To: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Cc: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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.albe@xxxxxxxxxxx>
Date: Wed, 11 Jun, 2025, 12:13 pm
Subject: Re: Upgrade from 12.22 to 16
To: Wasim Devale <wasimd60@xxxxxxxxx>, Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>

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