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@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@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@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
