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.klaver@xxxxxxxxxxx
