public inbox for [email protected]
help / color / mirror / Atom feedFrom: Gaspare Boscarino, P.Eng. <[email protected]>
To: DINESH NAIR <[email protected]>
Cc: Wasim Devale <[email protected]>
Cc: Ron Johnson <[email protected]>
Cc: pgsql-admin <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Upgrade from 12.22 to 16
Date: Mon, 16 Jun 2025 11:10:22 -0700
Message-ID: <CALFaTbM=Dd2Vcfcu=esVcYRLjBVTT2_XhzNgm-ig5GCDdtcYFw@mail.gmail.com> (raw)
In-Reply-To: <PN2P287MB051256EC6250B0CD5E5C66A19C71A@PN2P287MB0512.INDP287.PROD.OUTLOOK.COM>
References: <CAB5fag5dJZj-woa92nu+nO22J08UAzXeaDZAnPJQ_TQxhKPtLQ@mail.gmail.com>
<[email protected]>
<CAB5fag7za_UOfax3Yb7meGRUm4sC5gdOdhMugM5Eafq_BMsySQ@mail.gmail.com>
<AS8PR01MB7957F08B08BCA4F6ABDC069AF775A@AS8PR01MB7957.eurprd01.prod.exchangelabs.com>
<CANzqJaDOCKSDEd+NMN8gWmjZ-C+YsNK7=NzNbDRZV1OqHS0Suw@mail.gmail.com>
<CAB5fag75n7GgAn3Gx1Y0RXfy2W4Mg29P5ymTxjx+6hs+g=_yRg@mail.gmail.com>
<PN2P287MB051256EC6250B0CD5E5C66A19C71A@PN2P287MB0512.INDP287.PROD.OUTLOOK.COM>
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 <[email protected]>
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
>
> <https://www.postgresql.org/docs/current/logical-replication-restrictions.html;
> PostgreSQL: Documentation: 17: 29.7. Restrictions
> <https://www.postgresql.org/docs/current/logical-replication-restrictions.html;
> 29.7. Restrictions # Logical replication currently has the following
> restrictions or missing functionality. These might be addressed in future
> releases. The …
> www.postgresql.org
> Another useful link on enabling replication
>
>
> https://dev.to/raselmahmuddev/how-to-set-up-postgresql-logical-replication-use-cases-and-step-by-ste...
>
> <https://dev.to/raselmahmuddev/how-to-set-up-postgresql-logical-replication-use-cases-and-step-by-ste...;
> How to Set Up PostgreSQL Logical Replication: Use Cases and Step-by-Step
> Guide.
> <https://dev.to/raselmahmuddev/how-to-set-up-postgresql-logical-replication-use-cases-and-step-by-ste...;
> 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 main
> database (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 the performance of the website or
> app.
> dev.to
>
>
>
>
> ------------------------------
> *From:* Wasim Devale <[email protected]>
> *Sent:* Saturday, June 14, 2025 8:23 PM
> *To:* Ron Johnson <[email protected]>
> *Cc:* pgsql-admin <[email protected]>; Pgsql-admin <
> [email protected]>
> *Subject:* Re: Upgrade from 12.22 to 16
>
> You don't often get email from [email protected]. Learn why this is
> important <https://aka.ms/LearnAboutSenderIdentification;
> 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, <[email protected]>
> wrote:
>
> On Wed, Jun 11, 2025 at 2:57 AM Domen Šetar <[email protected]> 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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Upgrade from 12.22 to 16
In-Reply-To: <CALFaTbM=Dd2Vcfcu=esVcYRLjBVTT2_XhzNgm-ig5GCDdtcYFw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox