public inbox for [email protected]  

help / color / mirror / Atom feed

From: Asad Ali <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Durgamahesh Manne <[email protected]>
Cc: pgsql-general <[email protected]>
Cc: PostgreSQL mailing lists <[email protected]>
Subject: Re: Pgsql 16 to 14 using builtin logical
Date: Sat, 26 Oct 2024 22:06:33 +0500
Message-ID: <CAJ9xe=v3QX-Q4vmKYfos_UG75BD9j_Q_ekAu5G501o+Niy6fkA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJCZko+aaFkt8C+oXQFZYBUCD4f_gkAroaE1ZQemtdqNr+W=xQ@mail.gmail.com>
	<CAJ9xe=sLOZQ26JF==dNwmhh0LSkLgwMhsxXAH2e1J1CqkyHaBw@mail.gmail.com>
	<[email protected]>

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]
>
>

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Pgsql 16 to 14 using builtin logical
  In-Reply-To: <CAJ9xe=v3QX-Q4vmKYfos_UG75BD9j_Q_ekAu5G501o+Niy6fkA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox