Pglogical 2.3.0 in AWS RDS 12.2

From: Igor Polishchuk <ora4dba(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Pglogical 2.3.0 in AWS RDS 12.2
Date: 2020-06-01 16:39:40
Message-ID: A51655C0-BDD0-4F52-8DC5-2672AADA32D0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everybody,
Has anybody succeeded with using pglogical in AWS Postgresql 12.2?
They have pglogical v2.3.0, and it has this issue https://github.com/2ndQuadrant/pglogical/issues/240 <https://github.com/2ndQuadrant/pglogical/issues/240>, which was fixed in the 2.3.1.
However, one cannot upgrade pglogical to 2.3.1 in RDS. Just curious if somebody found a work around. Otherwise, it seems unusable with RDS v12.2 right now.
The specific issue is:

The replication just does not start after creating a subscription. If I try synchronize, I see:

select pglogical.alter_subscription_synchronize('subscription1');
ERROR: could not get table list: ERROR: syntax error at or near "."
LINE 1: ...i.att_list, i.has_row_filter, i.nspname as i.nsptarget…

In the db log:
2020-06-01 05:05:59 UTC;user=replication;db=demandbase_production;app=subscription1_sync;client=3.217.57.139(10005);[52691-3] ERROR: syntax error at or near "." at character 89
2020-06-01 05:05:59 UTC;user=replication;db=demandbase_production;app=subscription1_sync;client=3.217.57.139(10005);[52691-4] STATEMENT: SELECT i.relid, i.nspname, i.relname, i.att_list, i.has_row_filter, i.nspname as i.nsptarget, i.relname as i.reltarget FROM (SELECT DISTINCT relid FROM pglogical.tables WHERE set_name = ANY(ARRAY['default','default_insert_only','ddl_sql'])) t, LATERAL pglogical.show_repset_table_info(t.relid, ARRAY['default','default_insert_only','ddl_sql']) i

In GIT:
user(at)MacBook-Pro pglogical (HEAD detached at REL2_3_1) $ git checkout REL2_3_0
Previous HEAD position was 19d6f4f Merge branch 'pglogical2-fix-revert' into REL2_x_STABLE
HEAD is now at 4d53ca4 pglogical_create_subscriber: Fix for PostgreSQL 12

user(at)MacBook-Pro pglogical (HEAD detached at REL2_3_0) $ grep -R "i.nspname as i.nsptarge" *
pglogical_rpc.c: " i.has_row_filter, i.nspname as i.nsptarget, i.relname as i.reltarget"
ipolishchuk(at)MacBook-Pro pglogical (HEAD detached at REL2_3_0) $

Source Postgresql 9.6 pglogical 2.3.1 or 2.3.2

Target AWS RDS Postgresql 12.2 pglogical 2.3.0

Thank you
Igor Polishchuk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2020-06-01 18:08:18 Re: Oracle vs. PostgreSQL - a comment
Previous Message Ying Lu 2020-06-01 16:01:17 Re: psql12.3 + jdbc_fdw - return wrong query results by using OR