Thread

1. Using replication to upgrade db from 12 to 16

   Frank Komsic <komsicf@shoeicanada.com> — 2024-07-20T17:01:37Z

   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
   

2. Re: Using replication to upgrade db from 12 to 16

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-20T17:45:09Z

   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@shoeicanada.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
   >
   

3. Re: Using replication to upgrade db from 12 to 16

   Frank Komsic <komsicf@shoeicanada.com> — 2024-07-20T17:59:44Z

   Hi Zashif,
   
   I read somewhere that it was possible to have a replication on an Upgraded major version I believe by using logical replication?
   
   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.zeeshan@gmail.com>
   Date: Saturday, July 20, 2024 at 1:45 PM
   To: Frank Komsic <komsicf@shoeicanada.com>
   Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.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@shoeicanada.com<mailto:komsicf@shoeicanada.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
   

4. Re: Using replication to upgrade db from 12 to 16

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-20T18:09:15Z

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

5. Re: Using replication to upgrade db from 12 to 16

   Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com> — 2024-07-22T17:00:00Z

   Στις 20/7/24 20:01, ο/η Frank Komsic έγραψε:
   >
   > 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?
   >
   absolutely
   >
   > Thanks
   >
   >
   > Frank
   >
   -- 
   Achilleas Mantzios
     IT DEV - HEAD
     IT DEPT
     Dynacom Tankers Mgmt (as agents only)