public inbox for [email protected]help / color / mirror / Atom feed
Pgsql 16 to 14 using builtin logical 5+ messages / 3 participants [nested] [flat]
* Pgsql 16 to 14 using builtin logical @ 2024-10-26 03:28 Durgamahesh Manne <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Durgamahesh Manne @ 2024-10-26 03:28 UTC (permalink / raw) To: pgsql-general <[email protected]>; pgsql-general Hi Can we replicate 16 to 14 using builtin logical similarly pglogical? Regards Durga Mahesh ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pgsql 16 to 14 using builtin logical @ 2024-10-26 06:02 Asad Ali <[email protected]> parent: Durgamahesh Manne <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Asad Ali @ 2024-10-26 06:02 UTC (permalink / raw) To: Durgamahesh Manne <[email protected]>; +Cc: pgsql-general <[email protected]>; pgsql-general Hi Durgamahesh, Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using built-in logical replication. PostgreSQL's built-in logical replication allows for replicating data between different versions of PostgreSQL, provided the source version is higher than or equal to the target version. Regards, Asad On Sat, Oct 26, 2024, 8:28 AM Durgamahesh Manne <[email protected]> wrote: > Hi > > Can we replicate 16 to 14 using builtin logical similarly pglogical? > > Regards > Durga Mahesh > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pgsql 16 to 14 using builtin logical @ 2024-10-26 16:10 Adrian Klaver <[email protected]> parent: Asad Ali <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Adrian Klaver @ 2024-10-26 16:10 UTC (permalink / raw) To: Asad Ali <[email protected]>; Durgamahesh Manne <[email protected]>; +Cc: pgsql-general <[email protected]>; pgsql-general On 10/25/24 23:02, Asad Ali wrote: > Hi Durgamahesh, > > Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using > built-in logical replication. PostgreSQL's built-in logical replication > allows for replicating data between different versions of PostgreSQL, > provided the source version is higher than or equal to the target version. I am not following or maybe it's just your idea of what is the source and what is the target. In the common case of upgrading a database to a newer version the logical replication would be from the lower source to the higher target. > > Regards, > Asad > > > On Sat, Oct 26, 2024, 8:28 AM Durgamahesh Manne > <[email protected] <mailto:[email protected]>> wrote: > > Hi > > Can we replicate 16 to 14 using builtin logical similarly pglogical? > > Regards > Durga Mahesh > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pgsql 16 to 14 using builtin logical @ 2024-10-26 17:06 Asad Ali <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Asad Ali @ 2024-10-26 17:06 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: Durgamahesh Manne <[email protected]>; pgsql-general <[email protected]>; pgsql-general In the typical upgrade scenario, replication flows from the lower (older) version to the higher (newer) version. Here, the source is the older version (e.g., PostgreSQL 14), and the target is the newer version (e.g., PostgreSQL 16). Replicating from a higher version (PostgreSQL 16) to a lower one (PostgreSQL 14) is possible but unconventional and not usually done for upgrades. Best Regards, Asad Ali On Sat, Oct 26, 2024, 9:10 PM Adrian Klaver <[email protected]> wrote: > On 10/25/24 23:02, Asad Ali wrote: > > Hi Durgamahesh, > > > > Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using > > built-in logical replication. PostgreSQL's built-in logical replication > > allows for replicating data between different versions of PostgreSQL, > > provided the source version is higher than or equal to the target > version. > > I am not following or maybe it's just your idea of what is the source > and what is the target. In the common case of upgrading a database to a > newer version the logical replication would be from the lower source to > the higher target. > > > > > > Regards, > > Asad > > > > > > On Sat, Oct 26, 2024, 8:28 AM Durgamahesh Manne > > <[email protected] <mailto:[email protected]>> wrote: > > > > Hi > > > > Can we replicate 16 to 14 using builtin logical similarly pglogical? > > > > Regards > > Durga Mahesh > > > > -- > Adrian Klaver > [email protected] > > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Pgsql 16 to 14 using builtin logical @ 2024-10-26 17:51 Adrian Klaver <[email protected]> parent: Asad Ali <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Adrian Klaver @ 2024-10-26 17:51 UTC (permalink / raw) To: Asad Ali <[email protected]>; +Cc: Durgamahesh Manne <[email protected]>; pgsql-general <[email protected]>; pgsql-general On 10/26/24 10:06, Asad Ali wrote: > > In the typical upgrade scenario, replication flows from the lower > (older) version to the higher (newer) version. Here, the source is the > older version (e.g., PostgreSQL 14), and the target is the newer version > (e.g., PostgreSQL 16). So how does that fit with your statement?: "PostgreSQL's built-in logical replication allows for replicating data between different versions of PostgreSQL, provided the source version is higher than or equal to the target version." > > Replicating from a higher version (PostgreSQL 16) to a lower one > (PostgreSQL 14) is possible but unconventional and not usually done for > upgrades. > > > Best Regards, > Asad Ali > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-10-26 17:51 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-10-26 03:28 Pgsql 16 to 14 using builtin logical Durgamahesh Manne <[email protected]> 2024-10-26 06:02 ` Asad Ali <[email protected]> 2024-10-26 16:10 ` Adrian Klaver <[email protected]> 2024-10-26 17:06 ` Asad Ali <[email protected]> 2024-10-26 17:51 ` Adrian Klaver <[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