Pglogical 2.3.0 in AWS RDS 12.2

2020-06-01 Thread Igor Polishchuk
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

Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical

2020-05-30 Thread Igor Polishchuk
Hello, I need to replicate Postgresql 9.6 to AWS RDS Postgresql 12.2 with pg_logical. AWS RDS Pg 12.2 (target) only supports pg_logical 2.3.0. Can I use v2.3.1 on the source and v2.3.0 on the target? Thank you in advance Igor

Logical decoding plus streaming replication fail-over

2019-06-21 Thread Igor Polishchuk
, I need to create a new replication slot on a new muster and loose some database changes. Is there any work-around that would allow avoid loosing database changes on a logical replication slot after a fail-over? Postgres 10.8 on CentOS 7. -- Thanks Igor Polishchuk

How to create logical replication slot with NOEXPORT_SNAPSHOT in jdbc

2018-07-16 Thread Igor Polishchuk
.make(); log.info "created replication slot ${slotName}" } -- Thanks Igor Polishchuk