Downloads
Home   >   mailing lists

Thread: Re: Upgrade from 12.22 to 16

Re: Upgrade from 12.22 to 16

From
Laurenz Albe
Date:
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

Re: Upgrade from 12.22 to 16

From
Wasim Devale
Date:

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:13 pm
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

RE: Upgrade from 12.22 to 16

From
Domen Šetar
Date:

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:13 pm
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

Re: Upgrade from 12.22 to 16

From
Ron Johnson
Date:
On Wed, Jun 11, 2025 at 2:54 AM Wasim Devale <wasimd60@gmail.com> wrote:

I mean to say that we do not want to do the in place upgrade

Why not?  Using the default --copy option, there's minimal downtime, and the old database is still there in case you need to fall back, etc.
 

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:13 pm
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


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

Re: Upgrade from 12.22 to 16

From
"Gaspare Boscarino, P.Eng."
Date:
Hello Wasim,

I suggest the logical replication approach. As mentioned before in this thread, there are some limitations like DDL propagation, the need for primary keys, etc. However, those constraints are not problematic and if planned properly the result is excellent. I have used logical replication many times for databases with TB of data. 

Thank you.

Regards,

Gaspare

On Sun, Jun 15, 2025 at 9:43 PM DINESH NAIR <Dinesh_Nair@iitmpravartak.net> wrote:
Hope this  below  mentionsed on the restrictions  to be useful on the database schema and DDL commands are not replicated 

Another useful link on  enabling replication





From: Wasim Devale <wasimd60@gmail.com>
Sent: Saturday, June 14, 2025 8:23 PM
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Upgrade from 12.22 to 16

You don't often get email from wasimd60@gmail.com. Learn why this is important
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.

Thanks everyone.

Is there the restriction in logical replication because the database we have has all of it shown in the screenshot.


On Wed, 11 Jun, 2025, 8:59 pm Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Wed, Jun 11, 2025 at 2:57 AM Domen Šetar <domen.setar@izum.si> wrote:

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


Are you sure?  There _shouldn't_ be any problem with replicating to a new instance on the same machine.
 
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!


--
Gaspare Boscarino, P.Eng., M.Eng., MASc.
Founder and CEO
Theorema Systems Inc.
www.theoremasystems.com | +1 604-765-0121

Re: Upgrade from 12.22 to 16

From
David Okeamah
Date:
Can you help out 

DAVID OKEAMAH,DEVELOPER 
From: Gaspare Boscarino, P.Eng. <gaspare.boscarino@theoremasystems.com>
Sent: Monday, June 16, 2025 7:10:22 PM
To: DINESH NAIR <Dinesh_Nair@iitmpravartak.net>
Cc: Wasim Devale <wasimd60@gmail.com>; Ron Johnson <ronljohnsonjr@gmail.com>; pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Upgrade from 12.22 to 16
 
Hello Wasim,

I suggest the logical replication approach. As mentioned before in this thread, there are some limitations like DDL propagation, the need for primary keys, etc. However, those constraints are not problematic and if planned properly the result is excellent. I have used logical replication many times for databases with TB of data. 

Thank you.

Regards,

Gaspare

On Sun, Jun 15, 2025 at 9:43 PM DINESH NAIR <Dinesh_Nair@iitmpravartak.net> wrote:
Hope this  below  mentionsed on the restrictions  to be useful on the database schema and DDL commands are not replicated 

Another useful link on  enabling replication





From: Wasim Devale <wasimd60@gmail.com>
Sent: Saturday, June 14, 2025 8:23 PM
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Upgrade from 12.22 to 16

Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.

Thanks everyone.

Is there the restriction in logical replication because the database we have has all of it shown in the screenshot.


On Wed, 11 Jun, 2025, 8:59 pm Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Wed, Jun 11, 2025 at 2:57 AM Domen Šetar <domen.setar@izum.si> wrote:

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


Are you sure?  There _shouldn't_ be any problem with replicating to a new instance on the same machine.
 
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!


--
Gaspare Boscarino, P.Eng., M.Eng., MASc.
Founder and CEO
Theorema Systems Inc.
www.theoremasystems.com | +1 604-765-0121

Re: Upgrade from 12.22 to 16

From
"Gaspare Boscarino, P.Eng."
Date:
Hello David,

I can help but I am not sure if this is the right channel for further communication.

Thank you.

Regards,

Gaspare

On Mon, Jun 16, 2025 at 11:12 AM David Okeamah <whitneykiss741@gmail.com> wrote:
Can you help out 

DAVID OKEAMAH,DEVELOPER 
From: Gaspare Boscarino, P.Eng. <gaspare.boscarino@theoremasystems.com>
Sent: Monday, June 16, 2025 7:10:22 PM
To: DINESH NAIR <Dinesh_Nair@iitmpravartak.net>
Cc: Wasim Devale <wasimd60@gmail.com>; Ron Johnson <ronljohnsonjr@gmail.com>; pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Upgrade from 12.22 to 16
 
Hello Wasim,

I suggest the logical replication approach. As mentioned before in this thread, there are some limitations like DDL propagation, the need for primary keys, etc. However, those constraints are not problematic and if planned properly the result is excellent. I have used logical replication many times for databases with TB of data. 

Thank you.

Regards,

Gaspare

On Sun, Jun 15, 2025 at 9:43 PM DINESH NAIR <Dinesh_Nair@iitmpravartak.net> wrote:
Hope this  below  mentionsed on the restrictions  to be useful on the database schema and DDL commands are not replicated 

Another useful link on  enabling replication





From: Wasim Devale <wasimd60@gmail.com>
Sent: Saturday, June 14, 2025 8:23 PM
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Upgrade from 12.22 to 16

Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.

Thanks everyone.

Is there the restriction in logical replication because the database we have has all of it shown in the screenshot.


On Wed, 11 Jun, 2025, 8:59 pm Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Wed, Jun 11, 2025 at 2:57 AM Domen Šetar <domen.setar@izum.si> wrote:

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


Are you sure?  There _shouldn't_ be any problem with replicating to a new instance on the same machine.
 
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!


--
Gaspare Boscarino, P.Eng., M.Eng., MASc.
Founder and CEO
Theorema Systems Inc.
www.theoremasystems.com | +1 604-765-0121


--
Gaspare Boscarino, P.Eng., M.Eng., MASc.
Founder and CEO
Theorema Systems Inc.
www.theoremasystems.com | +1 604-765-0121