I missed to mentioned in the last. On Sat, Oct 26, 2024, 10:51 PM Adrian Klaver <adrian.kla...@aklaver.com> 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 > adrian.kla...@aklaver.com > >
