Thread: Pgsql 16 to 14 using builtin logical

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 
> <maheshpostgres9@gmail.com <mailto:maheshpostgres9@gmail.com>> wrote:
> 
>     Hi
> 
>     Can we replicate 16 to 14 using builtin logical similarly pglogical?
> 
>     Regards
>     Durga Mahesh
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

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
adrian.klaver@aklaver.com

On 10/26/24 11:38, Asad Ali wrote:
> I missed to mentioned in the last.

?



-- 
Adrian Klaver
adrian.klaver@aklaver.com

I have tested it around 3 - 4 years ago.
Logical replication is backward compatible as well.

So 16 to 14 does work :)