Re: Pgsql 16 to 14 using builtin logical

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Asad Ali <asadalinagri(at)gmail(dot)com>, Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pgsql 16 to 14 using builtin logical
Date: 2024-10-26 16:10:40
Message-ID: 1e16e035-e7e5-460a-86f8-9a207fd2ffef@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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
> <maheshpostgres9(at)gmail(dot)com <mailto:maheshpostgres9(at)gmail(dot)com>> wrote:
>
> Hi
>
> Can we replicate 16 to 14 using builtin logical similarly pglogical?
>
> Regards
> Durga Mahesh
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Asad Ali 2024-10-26 17:06:33 Re: Pgsql 16 to 14 using builtin logical
Previous Message Asad Ali 2024-10-26 06:02:11 Re: Pgsql 16 to 14 using builtin logical