Re: Logical replication from PG v13 and below to PG v14 (devel version) is not working.
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: Ashutosh Sharma <ashu.coek88@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-09-24T06:25:19Z
Lists: pgsql-hackers
On Tue, Sep 22, 2020 at 5:15 PM Dilip Kumar <dilipbalaut@gmail.com> wrote: > > On Tue, Sep 22, 2020 at 12:02 PM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > > > I am not sure if this suggestion makes it better than what is purposed > > by Dilip but I think we can declare them in define number order like > > below: > > #define LOGICALREP_PROTO_MIN_VERSION_NUM 1 > > #define LOGICALREP_PROTO_VERSION_NUM 1 > > #define LOGICALREP_PROTO_STREAM_VERSION_NUM 2 > > #define LOGICALREP_PROTO_MAX_VERSION_NUM LOGICALREP_PROTO_STREAM_VERSION_NUM > > Done this way. > - options.proto.logical.proto_version = LOGICALREP_PROTO_VERSION_NUM; + options.proto.logical.proto_version = MySubscription->stream ? + LOGICALREP_PROTO_STREAM_VERSION_NUM : LOGICALREP_PROTO_VERSION_NUM; Here, I think instead of using MySubscription->stream, we should use server/walrecv version number as we used at one place in tablesync.c. Because say if we decide to add something additional for decode of prepared xacts in PG14 then this check needs to be extended for stream and prepared where as server version number check won't need to be changed. -- With Regards, Amit Kapila.
Commits
-
Fix the logical replication from HEAD to lower versions.
- 079d0cacf4fe 14.0 landed
-
Add support for streaming to built-in logical replication.
- 464824323e57 14.0 cited