Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical

Igor Polishchuk wrote on 5/30/20 9:33 PM:

Hello,
I need to replicate�Postgresql 9.6 to �AWS RDS Postgresql 12.2 with
pg_logical.
AWS RDS Pg 12.2 (target) only supports pg_logical 2.3.0.
Can I use v2.3.1 on the source and v2.3.0 on the target?

We had lots of issues with pglogical when we accidentally introduced a
similar minor version mismatch in the past; I would recommend keeping
the version the same on both sides.

On 2020-05-31 06:33, Igor Polishchuk wrote:

I need to replicate�Postgresql 9.6 to �AWS RDS Postgresql 12.2 with
pg_logical.
AWS RDS Pg 12.2 (target) only supports pg_logical 2.3.0.
Can I use v2.3.1 on the source and v2.3.0 on the target?

In principle yes, since the compatibility is controlled by a protocol
version that is separate from the release version.

Note, however, that 2.3.1 is a bug-fix release on top of 2.3.0, and
there is now also a 2.3.2. Just like with PostgreSQL core, it's
advisable to use the latest minor release, and if anything goes wrong,
the first piece of advice would likely be to upgrade.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services