public inbox for [email protected]
help / color / mirror / Atom feedFrom: Gaspare Boscarino, P.Eng. <[email protected]>
To: David Okeamah <[email protected]>
Cc: 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:30:58 -0700
Message-ID: <CALFaTbPp+cRQ5MhSkSThom9f2soXRV=2qam_x0ue6gW9dD2W9Q@mail.gmail.com> (raw)
In-Reply-To: <AS4PR03MB85062F88F48A61671870648DF770A@AS4PR03MB8506.eurprd03.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>
<CALFaTbM=Dd2Vcfcu=esVcYRLjBVTT2_XhzNgm-ig5GCDdtcYFw@mail.gmail.com>
<AS4PR03MB85062F88F48A61671870648DF770A@AS4PR03MB8506.eurprd03.prod.outlook.com>
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 <[email protected]>
wrote:
> Can you help out
>
> DAVID OKEAMAH,DEVELOPER
> ------------------------------
> *From:* Gaspare Boscarino, P.Eng. <[email protected]>
> *Sent:* Monday, June 16, 2025 7:10:22 PM
> *To:* DINESH NAIR <[email protected]>
> *Cc:* Wasim Devale <[email protected]>; Ron Johnson <
> [email protected]>; pgsql-admin <[email protected]>;
> Pgsql-admin <[email protected]>
> *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 <[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
>
--
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], [email protected]
Subject: Re: Upgrade from 12.22 to 16
In-Reply-To: <CALFaTbPp+cRQ5MhSkSThom9f2soXRV=2qam_x0ue6gW9dD2W9Q@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