Re: Using replication to upgrade db from 12 to 16

Hi Frank

On Sat, Jul 20, 2024 at 11:00 PM Frank Komsic <komsicf(at)shoeicanada(dot)com>
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 <kashi(dot)zeeshan(at)gmail(dot)com>
> *Date: *Saturday, July 20, 2024 at 1:45 PM
> *To: *Frank Komsic <komsicf(at)shoeicanada(dot)com>
> *Cc: *pgsql-sql(at)lists(dot)postgresql(dot)org <pgsql-sql(at)lists(dot)postgresql(dot)org>
> *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 <komsicf(at)shoeicanada(dot)com>
> 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
>
>