pglogical

pglogical copied to clipboard

Hello, I have encountered strange problem with logical replication via `pglogical` plugin. I've spent many hours debugging it but I'm stuck and I guess it's kind of a bug. Let...

Krzysiek555

FATAL: CONFLICT: remote DELETE on relation .. replica identity index .. (tuple not found). Resolution: skip.

1

1 provider, 1 subscriber - postgresql 13 on both pglogical 2.3.3 I keep getting this on the subscriber, after which the subscription shows as down. It happens on several tables....

gilesmca

The postgres log handler will call `abort()` if it sees a `PANIC` level log and will call `exit()` if it sees a `FATAL` level log. So if `pglogical.conflict_log_level` is set...

tommyzli

Tables are not synced even when their "sync_status" are "r"

4

I managed to setup `pglogical 2.2.0` logical replication from a Postgres 9.6.10 RDS instance to a Postgres 10.4 RDS instance. The subscription check `SELECT subscription_name, status FROM pglogical.show_subscription_status();` returns `replicating`....

beyondbill

Hi, Newly created tables are not syncing into the replica server. even though the already created table's contents are syncing. I followed the below document to configure the replication on...

asharabu

OS : suse linux 12 sp5 export PGUSER=postgres export PGHOME=/opt/PostgresXL export PG_CONFIG=/opt/PostgresXL/bin/pg_config export LD_LIBRARY_PATH=/opt/PostgresXL/lib: 1) make : gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard...

lessdantu

add_table test fails intermittently on REL2_0_STABLE branch

13

Running `make regresscheck` on the tip of `REL2_0_STABLE` branch I see intermittent (maybe 20-40% of the time) failures in the `add_table` test: ``` Makefile:112: recipe for target 'regresscheck' failed ***...

mbanck

pglogical_create_subscriber and non-default ports

1

`pglogical_create_subscriber` takes a `--publisher-dsn` and a `--subscriber-dsn` option where you can specify non-default ports if needed. However, it seems to me that `pglogical_create_subscriber` starts the subscriber postgres on the default...

mbanck

New column not synchronizing

1

Hello! I have 2 servers with Postgresql 9.4. On both installed pglogical version pglogical_1.2.2 from source (all other version not working in this environment). On source server side I made...

Growlert

PGLogical 2.3.2 on Debian servers. All replicated tables are in state replicating - when checked by pglogical.show_subscription_table() or by pglogical.local_sync_status, but pglogical.queue is not empty - with Q and A...

ZiBiS