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 1uREI4-008pyT-UK for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 18:10:41 +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 1uREI3-002JBI-0M for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jun 2025 18:10:39 +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 1uREI2-002J7t-2u for pgsql-admin@lists.postgresql.org; Mon, 16 Jun 2025 18:10:39 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uREHz-002MCu-18 for pgsql-admin@lists.postgresql.org; Mon, 16 Jun 2025 18:10:37 +0000 Received: by mail-pj1-x1033.google.com with SMTP id 98e67ed59e1d1-3138e64b42aso5465000a91.0 for ; Mon, 16 Jun 2025 11:10:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=theoremasystems-com.20230601.gappssmtp.com; s=20230601; t=1750097434; x=1750702234; 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=RMsN7uP16l/0nIfPh6MYst4gVYoscFlTHM61yOV7vcs=; b=LBRelCwO3Y/ikeMMpqT3zbf3SgfXLMAmieeCf/EtW9DIY0SbFkjdgb3FcouUE5Zwql g4KpC6i8z5mE13cGAJKDHihfOGZcW+7rFF5e3qKEaviPBwWP0MkeUDahm1HqHUopkEho Ak9iaLrvfBx16fKG7UNBkqM9M1MuDxFzHAfUUeHian3J/hk6qTFsNPgK+KrXOILiPYHG rLu247CgPNnIYBMALcNISLBFeWgUTu9zDinWoEchXp942R0syAwCcg66nYaHftYLWCkd lOG9x4MG9xNzr4CkJT5iTc3kD6jTZySn9mxGHgZg1yE4skd/iRwRtvflxJYG8EX11BC4 gJow== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750097434; x=1750702234; 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=RMsN7uP16l/0nIfPh6MYst4gVYoscFlTHM61yOV7vcs=; b=SWTY1uQ8OGE7FX6J/ZGKzqqU+h5ueZ+6eukXcYlxdMSNVEYJjso0yjOwtjSTY6Pz6G hPbN+WS+Lr7wceMan4UDAj8GABo/tBOMc8Cyv0dK4fDXOuxBzQppRolbMF2FYdNy6gyp 3HaT0LZ1TH5+tRYXrPYoEIYdMWsWas5VTwPe4XNTdooY1KTIyIcY73A9f4GKd1Rvbs3q iAxaFeUEKnCn3NgjXPX2Xw2AKzvAp8Vu7cF/9fZ92VDp6Dc0x7pbWVU5UqFgu3p55MJr /b4zIWrZUQ782ohom3UHV3sxg1yngQ/3CCCQ6FGr+S+rqmWTOOYmLeu9p2itw/qgtrs6 he8w== X-Forwarded-Encrypted: i=1; AJvYcCXogz+qS8BD+i6jBvWCcJbfsOrrh5RGG37scSWea5+SliGjFbV4Fpz25ul4b4x431z4VdA7F2TtpSAZRA==@lists.postgresql.org X-Gm-Message-State: AOJu0YyBjMusgA9zdTPbAi8oOZkkCopwG6zZJkWNZ+dAMd+8OpKiz1NW /AmYnfyTPJIMlrxkWHo4OTJkpnf6GPpA1/qG2MJv3uxcagoYg68iJgP2S5bluy/jdJFP1h3Zrnp /BJ7LVvmnruR0UFGcpBep5KHZBwZfEM/rJqKkgXnkaQ== X-Gm-Gg: ASbGncsW4XORmxXEeVGV/QFLszDIGEAMW/GBDRAQDOxxyhpeF9f2Ax+ulomVPrN/zm6 YSIe4OrH+RsPwBQu6xvzOrleDsq9LMm3L/xHtbue++BYQRCIO00JTzp5bPyTL19jSwmqFsNdMIb u30ki7QLcs748uwJK9B27xxYYMxXbCc2R++hGe69sH8jvaHw1I3YSm X-Google-Smtp-Source: AGHT+IEVs3TscXiGUcaBa8EClChAvcyhbYnyZmtLX5/TisE16oNJBMMkpmNqd22UHTtahzqTzqz8yE1OYeXuY2dR6jc= X-Received: by 2002:a17:90b:4f81:b0:311:c1ec:7d05 with SMTP id 98e67ed59e1d1-313f1d86e3bmr14458216a91.35.1750097434159; Mon, 16 Jun 2025 11:10:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "Gaspare Boscarino, P.Eng." Date: Mon, 16 Jun 2025 11:10:22 -0700 X-Gm-Features: AX0GCFupWDTLylijp5wv9UMEC5-dwWjEzyRWaYhCxFntzwSraUSSexNBB2AB50U Message-ID: Subject: Re: Upgrade from 12.22 to 16 To: DINESH NAIR Cc: Wasim Devale , Ron Johnson , pgsql-admin , Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000e2c1080637b44ffc" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e2c1080637b44ffc Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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! > > --=20 Gaspare Boscarino, P.Eng., M.Eng., MASc. Founder and CEO *Theorema Systems Inc.* www.theoremasystems.com | +1 604-765-0121 --000000000000e2c1080637b44ffc Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Wasim,

I suggest=C2=A0= 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 databa= ses with TB of data.=C2=A0

Thank you.
Regards,

Gaspare

On Sun, Jun 15, 2025 at 9:43=E2=80=AFPM DINESH NAIR <Dinesh_Nair@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: Documentation: 17: 29.7. Re= strictions
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""<= /div>
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, <ronljohnson= jr@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 a= nd CEO
Theorema Systems Inc.
www.theor= emasystems.com | +1 604-765-0121
--000000000000e2c1080637b44ffc--