RE: Upgrade from 12.22 to 16 - Mailing list pgsql-admin

From Domen Šetar
Subject RE: Upgrade from 12.22 to 16
Date
Msg-id AS8PR01MB7957F08B08BCA4F6ABDC069AF775A@AS8PR01MB7957.eurprd01.prod.exchangelabs.com
Whole thread Raw
In response to Re: Upgrade from 12.22 to 16  (Wasim Devale <wasimd60@gmail.com>)
List pgsql-admin

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

 

 

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

Attachment

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Re: Upgrade from 12.22 to 16
Next
From: Kushal Shri
Date:
Subject: PostgreSQL Upgrade (v9.5 to v12) with Django 2.0