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