public inbox for [email protected]help / color / mirror / Atom feed
Using replication to upgrade db from 12 to 16 5+ messages / 3 participants [nested] [flat]
* Using replication to upgrade db from 12 to 16 @ 2024-07-20 17:01 Frank Komsic <[email protected]> 2024-07-20 17:45 ` Re: Using replication to upgrade db from 12 to 16 Kashif Zeeshan <[email protected]> 2024-07-22 17:00 ` Re: Using replication to upgrade db from 12 to 16 Achilleas Mantzios <[email protected]> 0 siblings, 2 replies; 5+ messages in thread From: Frank Komsic @ 2024-07-20 17:01 UTC (permalink / raw) To: [email protected] <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using replication to upgrade db from 12 to 16 2024-07-20 17:01 Using replication to upgrade db from 12 to 16 Frank Komsic <[email protected]> @ 2024-07-20 17:45 ` Kashif Zeeshan <[email protected]> 2024-07-20 17:59 ` Re: Using replication to upgrade db from 12 to 16 Frank Komsic <[email protected]> 1 sibling, 1 reply; 5+ messages in thread From: Kashif Zeeshan @ 2024-07-20 17:45 UTC (permalink / raw) To: Frank Komsic <[email protected]>; +Cc: [email protected] <[email protected]> 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 > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using replication to upgrade db from 12 to 16 2024-07-20 17:01 Using replication to upgrade db from 12 to 16 Frank Komsic <[email protected]> 2024-07-20 17:45 ` Re: Using replication to upgrade db from 12 to 16 Kashif Zeeshan <[email protected]> @ 2024-07-20 17:59 ` Frank Komsic <[email protected]> 2024-07-20 18:09 ` Re: Using replication to upgrade db from 12 to 16 Kashif Zeeshan <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Frank Komsic @ 2024-07-20 17:59 UTC (permalink / raw) To: Kashif Zeeshan <[email protected]>; +Cc: [email protected] <[email protected]> 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 <[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]<mailto:[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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using replication to upgrade db from 12 to 16 2024-07-20 17:01 Using replication to upgrade db from 12 to 16 Frank Komsic <[email protected]> 2024-07-20 17:45 ` Re: Using replication to upgrade db from 12 to 16 Kashif Zeeshan <[email protected]> 2024-07-20 17:59 ` Re: Using replication to upgrade db from 12 to 16 Frank Komsic <[email protected]> @ 2024-07-20 18:09 ` Kashif Zeeshan <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Kashif Zeeshan @ 2024-07-20 18:09 UTC (permalink / raw) To: Frank Komsic <[email protected]>; +Cc: [email protected] <[email protected]> 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 > > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using replication to upgrade db from 12 to 16 2024-07-20 17:01 Using replication to upgrade db from 12 to 16 Frank Komsic <[email protected]> @ 2024-07-22 17:00 ` Achilleas Mantzios <[email protected]> 1 sibling, 0 replies; 5+ messages in thread From: Achilleas Mantzios @ 2024-07-22 17:00 UTC (permalink / raw) To: [email protected] Στις 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) ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-07-22 17:00 UTC | newest] Thread overview: 5+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-07-20 17:01 Using replication to upgrade db from 12 to 16 Frank Komsic <[email protected]> 2024-07-20 17:45 ` Kashif Zeeshan <[email protected]> 2024-07-20 17:59 ` Frank Komsic <[email protected]> 2024-07-20 18:09 ` Kashif Zeeshan <[email protected]> 2024-07-22 17:00 ` Achilleas Mantzios <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox