Re: Pgsql 16 to 14 using builtin logical

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 <adrian(dot)klaver(at)aklaver(dot)com>
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
> > <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
>
>