pglogical
pglogical copied to clipboard
2ndQuadrant
Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
Hi, is there any updated link to documentation? Also google links to Whoops pages  .
Hi! We're using Pglogical to sync from Pg 12.8 to Pg 13.4, using `pglogical_create_subscriber`. We're on Ubuntu 20.04, using the debs from PGDG. I also tried using the pglogical 2.4.0...
Dear All, May I ask you about the pglogical on Postgresql 9.6? I got an issue as below: --------- LOG: could not receive data from client: Connection reset by peer...
Running a test generating load on source side. I can query pg_stat_statements and see the inserts/updates/deletes I executed. On the destination side I know changes are replicating across because this...
When I try to complie pglogical on EnterpriseDB 9.6, but I got error message as below.. :( ---------------------- pglogical_conflict.c: In function ‘find_index_tuple’: pglogical_conflict.c:188:4: error: too few arguments to function ‘XactLockTableWait’...
Hi, We have 1 way replication setup from A to B (i.e., A has Replication Set created and B has Subscription created). forward_origin is set to {}. INSERTS, UPDATES and...
I need to migrate my table into shard deployment. based on some column combination. table like: ```sql CREATE TABLE public.sometable ( id bigint NOT NULL, ....... ); ``` when I...
When testing pglogical on a clone of our production database, I kept running into an issue where the CATCHUP phase of table sync would stall indefinitely. It took me a...
With pglogical 2.2.2, postgresql 11.8, at times truncate does not happen on the subscriber, and so far from my tests it seems to be related to size of table/number of...
pglogical 2.3.4 postgresql 11.4 debian 9 **pglogical.queue table growth endless in multisubscribe mode when trying to add new table to the replication set** To reproduce need to deploy 3 pglogical...
Metadata
Owner
Metadata
Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.