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

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Igor Polishchuk <ora4dba(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical
Date: 2020-06-01 09:04:54
Message-ID: 16ae4569-0ed7-f2ac-b007-886fe8432c63@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2020-06-01 09:06:37 Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
Previous Message legrand legrand 2020-06-01 08:36:28 Re: pg_stat_sql_plans ALPHA released