Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical

Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical

From
Igor Polishchuk
Date:
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? 

Thank you in advance
Igor




Re: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical

From
Ben Chobot
Date:
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.

Re: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical

From
Peter Eisentraut
Date:
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