public inbox for [email protected]  

help / color / mirror / Atom feed

From: Kashif Zeeshan <[email protected]>
To: Frank Komsic <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Using replication to upgrade db from 12 to 16
Date: Sat, 20 Jul 2024 23:09:15 +0500
Message-ID: <CAAPsdhfKPPk-RQEvJsGNX4M1v6OyEwZH=RGv96Lwe65AnKw5aQ@mail.gmail.com> (raw)
In-Reply-To: <BL3PR05MB9236C3B7229A4C96734DAB61B3AE2@BL3PR05MB9236.namprd05.prod.outlook.com>
References: <BL3PR05MB9236BC5C51ED0E7B151C1FCCB3AE2@BL3PR05MB9236.namprd05.prod.outlook.com>
	<CAAPsdhfWrOTP9TcPhp4TJUDK2oMEO-=pNBHXo9zj2_TuLDw2dw@mail.gmail.com>
	<BL3PR05MB9236C3B7229A4C96734DAB61B3AE2@BL3PR05MB9236.namprd05.prod.outlook.com>

Hi Frank

On Sat, Jul 20, 2024 at 11:00 PM Frank Komsic <[email protected]>
wrote:

> Hi Zashif,
>
>
>
> I read somewhere that it was possible to have a replication on an Upgraded
> major version I believe by using logical replication?
>
The restrictions I mentioned are with Physical Replication.
You can use Logical Replication which doesn't have these restrictions but
it has some of its own e.g.
1. It supports replication of Tables only
2. It support only DML Commands (INSERT, UPDATE, DELETE) and TRUNCATE (with
some restrictions)

You can check the restrictions on following link

https://www.postgresql.org/docs/current/logical-replication-restrictions.html


Regards
Kashif Zeeshan

>
>
> Not sure myself, but was hoping there is a way as our application required
> some debugging after the upgrade due to improper concatenation of SQL
> statements that was not enforced in PGSQL-12.
>
>
>
> Thanks
>
> Frank
>
>
>
> *From: *Kashif Zeeshan <[email protected]>
> *Date: *Saturday, July 20, 2024 at 1:45 PM
> *To: *Frank Komsic <[email protected]>
> *Cc: *[email protected] <[email protected]>
> *Subject: *Re: Using replication to upgrade db from 12 to 16
>
> Hi Frank
>
>
>
> Streaming/Physical Replication requires that both Master and Standby are
> using the same OS and same PG major version.
>
>
>
> Thanks
>
> Kashif Zeeshan
>
>
>
> On Sat, Jul 20, 2024 at 10:01 PM Frank Komsic <[email protected]>
> wrote:
>
> Hi,
>
>
>
> Is it possible to maintain our MASTER db in Pgsql-12 and a replica
> database in Pgsql-16 as SLAVE for application testing with the latest live
> data?
>
>
>
> Thanks
>
>
> Frank
>
>

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]
  Subject: Re: Using replication to upgrade db from 12 to 16
  In-Reply-To: <CAAPsdhfKPPk-RQEvJsGNX4M1v6OyEwZH=RGv96Lwe65AnKw5aQ@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