Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread rajesh kumar
I have tested it around 3 - 4 years ago. Logical replication is backward compatible as well. So 16 to 14 does work :) On Sat, Oct 26, 2024, 17:16 Adrian Klaver wrote: > On 10/26/24 11:38, Asad Ali wrote: > > I missed to mentioned in the last. > > ? > > > > -- > Adrian Klaver > adrian.kla...@akl

Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread Adrian Klaver
On 10/26/24 11:38, Asad Ali wrote: I missed to mentioned in the last. ? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread Asad Ali
I missed to mentioned in the last. On Sat, Oct 26, 2024, 10:51 PM Adrian Klaver wrote: > 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.

Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread Adrian Klaver
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 wi

Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread Asad Ali
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

Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread Adrian Klaver
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 i

Re: Pgsql 16 to 14 using builtin logical

2024-10-25 Thread Asad Ali
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 ver