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.
Consider the following scenario: Provider sequence is 1 After sequence sync, subscriber sequence is 1000 (due to buffer) Record inserted to subscriber, gets ID 1000 1000 records inserted to provider...
The public documentation of pglogical says that pglogical setup and administration requires superuser privileges. It also mentions that it may later be extended to more granular privileges. We have a...
I am trying to setup schema level replication. All steps went through without any problem, however, when setting up subscriber on replica getting below error - 2021-12-06 17:05:49.218 PST [21888]...
Currently, this test case will produce a wrong set of data, when calling table_data_filtered() like we do for an initial table sync: ``` CREATE EXTENSION IF NOT EXISTS pglogical; CREATE...
in file pglogical_sync.c -----------------> function QuoteWindowsArgv static void not fixed
Our pglogical set up on production db sometime would show the subscription status is down, and I am not able to get it back to replicating. The postgres log is...
Hi All, I am using pglogical replication to create read replicas for certain tables in different DB from primary azure managed flexi server which have High availability configuration. At the...
**My Goal:** Bidirectional Replication, where all changes are synced **My Setup (Broken):** ```SQL ## DB -- A SELECT pglogical.create_subscription( subscription_name := 'legacy_sub', provider_dsn := 'REMOVED', replication_sets := ARRAY['default'], synchronize_data :=...
I have a PG12 cluster which was replicating with a PG10 primary. I disabled the subscription, then pg_upgraded from PG12 to PG13, installed pglogical 2.3.3, and tried to enable the...
**Setup:** - Provider: PG 9.4 with pglogical v2.2.2 - Subscriber: PG 12 with pglogical 2.3.0 **Expected Behavior:** Existing data would make it's way over from the 9.4 db to the...
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.