Pglogical 2.3.0 in AWS RDS 12.2

Поиск
Список
Период
Сортировка
От Igor Polishchuk
Тема Pglogical 2.3.0 in AWS RDS 12.2
Дата
Msg-id A51655C0-BDD0-4F52-8DC5-2672AADA32D0@gmail.com
обсуждение исходный текст
Ответы Re: Pglogical 2.3.0 in AWS RDS 12.2
Список 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, 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

В списке pgsql-general по дате отправления: