Search Postgresql Archives

Pglogical 2.3.0 in AWS RDS 12.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux