Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uREc2-008u2x-5W for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 18:31:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uREbz-002Y90-Rv for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 18:31:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uREby-002Y8G-H7 for pgsql-admin@lists.postgresql.org; Mon, 16 Jun 2025 18:31:16 +0000 Received: from mail-pj1-x102c.google.com ([2607:f8b0:4864:20::102c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uREbv-002MMR-13 for pgsql-admin@lists.postgresql.org; Mon, 16 Jun 2025 18:31:13 +0000 Received: by mail-pj1-x102c.google.com with SMTP id 98e67ed59e1d1-313bb9b2f5bso5675929a91.3 for ; Mon, 16 Jun 2025 11:31:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=theoremasystems-com.20230601.gappssmtp.com; s=20230601; t=1750098670; x=1750703470; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=s8F6dZHUk2Nl6gMkASnTvwRnwDpPHUANRfgsJOW70Fk=; b=OCdAo0TqHxsKr7sBdVIcxP2Se9vkcmeLDlcIP2m8UNbKSgOZXz1eFw4e7tWHRtSyVV iE7UUNJ5wFuPeAUj9p4mXG0JBTdOJTij3IK05UrjiJsX/TC/1Cdqmhr6gkxJZ8jJC7hX fFI7MCnDCEfoJW+drrG6tJQ4rcjA0fJceH/eujHcFZjBq5DLSjUm7rXXTZg5qO5PwyLz zr0KvHpwUcmwZSX+LMIW2vqVe+Dd281wtP9LeW1NZwU5oqsajbFVt65UWK1wjPAoiXc/ LjH4hqzJ+iBxObuvAo6R6j0Ry82IWzUZVIWf6HTn5gR1K3SUpvb4b2CWKbHHD9iy0PWt 9vwQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750098670; x=1750703470; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=s8F6dZHUk2Nl6gMkASnTvwRnwDpPHUANRfgsJOW70Fk=; b=VJBbE+/lNpy0RIrcIJvO5dVKQD2Gw/7L/WGN16tzvoSAwXukldeWGfxr3gRT4s9HYo QtTMsD/ZnWsreoj5GYrR6Imm15z0ICVu5fpFWVJ12m9u/MfFgZANQ2b35V6zVZoC1Eif j9xa8hfjsCH+Xdz3I14mXRetDE8/ciZCNlRRxdU6Xs6sMnkxtND6qQfqhU7s9nE9lLZx VZzeIWEHnj1sM5CSqC+jWXjWIvh4aPyxV3rfRcARjTQ+vfIBCOR2oGp5y/nWkixQD31G MUD8wvpnNx8miGnHvR6jTN4WZkCCJV776x9Sq9SongNjPEZfJloCAGPelMLDIa2Y+pLN J+pg== X-Forwarded-Encrypted: i=1; AJvYcCUFz88/p8nxlt7lQeVEHNcrOyb1L/DGeu6KTQnv8xXQFfHWV89Uiy3rJ+Fj4cI1Z16xqh/rbty5LhNjxg==@lists.postgresql.org X-Gm-Message-State: AOJu0Yz3UjlcX1cj9xJiymDAf0h80QxviMcG8cyHldmikSs9LWErkCEJ nsAbvqhXqBh1LSsTvQ01N9kEVErcGr4I/qFN8sPhAf5syliOAqy3lHV5HGlxN880KX1OFQtYMQ6 DGvobLQUOYGkPASTtRnIPcDjLDoZFZG6Q8MUJm/1DUA== X-Gm-Gg: ASbGncs5JQg4i3kxy6FoqDTj9pRSlC+gsWuE1beB24AcJN5b2uBnlNUTQSkEYApBt+j EAe7OyO63E2451fPlSeaXya1H1kxf+msuZ59KSfEM3pPacnpeqIGMelGl6/LVVJh2IkD3CvAccX vkZagWvO/fFrEWddsurm3WABgNz1Uirvcnp5FLYQGEuQ== X-Google-Smtp-Source: AGHT+IFeYgb/q7KPZg1cC+APkjmq9RuwudPlSiVzH9dnuhO/7Tg28vEy6fLSWEClT8S47xVbiN2H2R1zGpamqvXWgRc= X-Received: by 2002:a17:90b:1c86:b0:30e:8c5d:8ed with SMTP id 98e67ed59e1d1-313f1ce689emr14434829a91.19.1750098670215; Mon, 16 Jun 2025 11:31:10 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "Gaspare Boscarino, P.Eng." Date: Mon, 16 Jun 2025 11:30:58 -0700 X-Gm-Features: AX0GCFue4agZ7U-ZkQ4LWe3pVmeKTtANx7vRFytYxEQJFvmcgqwNG0T0nF_AbSo Message-ID: Subject: Re: Upgrade from 12.22 to 16 To: David Okeamah Cc: DINESH NAIR , Wasim Devale , Ron Johnson , pgsql-admin , Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000008f7caf0637b499e0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008f7caf0637b499e0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFAM David Okeamah wrote: > Can you help out > > DAVID OKEAMAH,DEVELOPER > ------------------------------ > *From:* Gaspare Boscarino, P.Eng. > *Sent:* Monday, June 16, 2025 7:10:22 PM > *To:* DINESH NAIR > *Cc:* Wasim Devale ; Ron Johnson < > ronljohnsonjr@gmail.com>; pgsql-admin ; > Pgsql-admin > *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=E2=80=AFPM DINESH NAIR > wrote: > > Hope this below mentionsed on the restrictions to be useful on the > database schema and DDL commands are not replicated > > > https://www.postgresql.org/docs/current/logical-replication-restrictions.= html > > > PostgreSQL: Documentation: 17: 29.7. Restrictions > > 29.7. Restrictions # Logical replication currently has the following > restrictions or missing functionality. These might be addressed in future > releases. The =E2=80=A6 > www.postgresql.org > Another useful link on enabling replication > > > https://dev.to/raselmahmuddev/how-to-set-up-postgresql-logical-replicatio= n-use-cases-and-step-by-step-guide-536b > > > How to Set Up PostgreSQL Logical Replication: Use Cases and Step-by-Step > Guide. > > Real-World Use Case 2: E-commerce Platforms Use Case: An e-commerce > platform uses logical replication to keep the data in sync between the ma= in > database (handling customer transactions) and a separate reporting databa= se > (used for analytics).This ensures that the system can generate real-time > reports and insights without affecting the performance of the website or > app. > dev.to > > > > > ------------------------------ > *From:* Wasim Devale > *Sent:* Saturday, June 14, 2025 8:23 PM > *To:* Ron Johnson > *Cc:* pgsql-admin ; 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=E2=80=99s 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=E2=80=AFpm Ron Johnson, > wrote: > > On Wed, Jun 11, 2025 at 2:57=E2=80=AFAM Domen =C5=A0etar 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 , and butter sauce. > Don't boil me, I'm still alive. > lobster! > > > > -- > Gaspare Boscarino, P.Eng., M.Eng., MASc. > Founder and CEO > *Theorema Systems Inc.* > www.theoremasystems.com | +1 604-765-0121 > --=20 Gaspare Boscarino, P.Eng., M.Eng., MASc. Founder and CEO *Theorema Systems Inc.* www.theoremasystems.com | +1 604-765-0121 --0000000000008f7caf0637b499e0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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 1= 1:12=E2=80=AFAM David Okeamah <whitneykiss741@gmail.com> wrote:
Can you help out=C2=A0

DAVID OKEAMAH,DEVELOPER=C2=A0
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>; pgs= ql-admin <pgsql-admin@postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgres= ql.org>
Subject: Re: Upgrade from 12.22 to 16
=C2=A0
Hello Wasim,

I suggest=C2=A0the logical replication approach. As mentioned before i= n this thread, there are some limitations like DDL propagation, the need fo= r 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.= =C2=A0

Thank you.

Regards,

Gaspare

On Sun, Jun 15, 2025 at 9:43=E2=80=AFPM DINESH NAIR <Dinesh_Nai= r@iitmpravartak.net> wrote:
Hope this=C2=A0 below=C2=A0 mentionsed on the restrictions=C2=A0 to be usef= ul on the database schema and DDL commands are not replicated=C2=A0

3D""
PostgreSQL: Doc= umentation: 17: 29.7. Restrictions
29.7.&nbsp;Restrictions # Logical replication currently has the followi= ng restrictions or missing functionality. These might be addressed in futur= e releases. The =E2=80=A6
www.postgresql.org<= /a>
Another useful link on=C2=A0 enabling replication

3D""
How to Set Up PostgreSQL Logical Replication: Use Cases and Step-by-Step Guide.
Real-World Use Case 2: E-commerce Platforms Use Case: An e-commerce platfor= m uses logical replication to keep the data in sync between the main databa= se (handling customer transactions) and a separate reporting database (used= for analytics).This ensures that the system can generate real-time reports and insights without affecting t= he performance of the website or app.
dev.to




From:=C2=A0Wasim Devale <wasimd60@gmail.com>
Sent:=C2=A0Saturday, June 14, 2025 8:23 PM
To:=C2=A0Ron Johnson <ronljohnsonjr@gmail.com>
Cc:=C2=A0pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-admin <pgsql-a= dmin@lists.postgresql.org>
Subject:=C2=A0Re: 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 a= n external source. Please verify the sender=E2=80=99s identity before click= ing 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=E2=80=AFpm Ron John= son, <ronljohnsonjr@gmail.com> wrote:
On Wed, Jun 11, 2025 at 2:57=E2=80=AFAM Domen = =C5=A0etar <domen.setar@izum.si> wrote:

You can use logic= al replication if new version of your postgres is on other host.


Are you sure?=C2=A0 There _shouldn't_ be a= ny problem with replicating to a new instance on the same machine.
=C2=A0
--
Death to <Redacted>, and butter sauce. <= /div>
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.
<= a href=3D"http://www.theoremasystems.com" target=3D"_blank">www.theoremasys= tems.com | +1 604-765-0121
--0000000000008f7caf0637b499e0--