public inbox for [email protected]  

help / color / mirror / Atom feed

Re: Pgsql 16 to 14 using builtin logical
3+ messages / 3 participants
[nested] [flat]

* Re: Pgsql 16 to 14 using builtin logical
@ 2024-10-26 18:38  Asad Ali <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Asad Ali @ 2024-10-26 18:38 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; +Cc: Durgamahesh Manne <[email protected]>; pgsql-general <[email protected]>; pgsql-general

I missed to mentioned in the last.

On Sat, Oct 26, 2024, 10:51 PM Adrian Klaver <[email protected]>
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., 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
> [email protected]
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pgsql 16 to 14 using builtin logical
@ 2024-10-26 21:15  Adrian Klaver <[email protected]>
  parent: Asad Ali <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Adrian Klaver @ 2024-10-26 21:15 UTC (permalink / raw)
  To: Asad Ali <[email protected]>; +Cc: Durgamahesh Manne <[email protected]>; pgsql-general <[email protected]>; pgsql-general

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

?



-- 
Adrian Klaver
[email protected]







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pgsql 16 to 14 using builtin logical
@ 2024-10-26 21:53  rajesh kumar <[email protected]>
  parent: Adrian Klaver <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: rajesh kumar @ 2024-10-26 21:53 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; +Cc: Asad Ali <[email protected]>; Durgamahesh Manne <[email protected]>; pgsql-general <[email protected]>; pgsql-general

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 <[email protected]> wrote:

> On 10/26/24 11:38, Asad Ali wrote:
> > I missed to mentioned in the last.
>
> ?
>
>
>
> --
> Adrian Klaver
> [email protected]
>
>
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2024-10-26 21:53 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-26 18:38 Re: Pgsql 16 to 14 using builtin logical Asad Ali <[email protected]>
2024-10-26 21:15 ` Adrian Klaver <[email protected]>
2024-10-26 21:53   ` rajesh kumar <[email protected]>

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