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

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Igor Polishchuk <ora4dba(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical
Date: 2020-05-31 14:56:04
Message-ID: 2df618fa-bd58-8b4f-5d6a-c47287bf694b@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tony 2020-05-31 15:05:26 pg_dump of database with numerous objects
Previous Message Tim Cross 2020-05-31 13:26:07 Re: Oracle vs. PostgreSQL - a comment