2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 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.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 153 forks source link

Can't launch full synchronization #360

Open krast-napoli opened 2 years ago

krast-napoli commented 2 years ago

Hello, my replication is OK, but i want to make full synchronization, to add data, that had been updated before I started replication. My steps: On provider: select pglogical.replication_set_add_table(set_name := 'my_set', relation := 'my_table', synchronize_data := true); On subscriber:

SELECT pglogical.create_subscription(
    subscription_name := 'my_subscription',
    provider_dsn := '...',
    replication_sets := '{my_set}'
);

select pglogical.alter_subscription_synchronize('my_subscription');

After that I have my subscription at replicating status, new data on provider is replicating, I see it. But old data haven't been updated on subscriber

My English isn't well, so I describe more carefully For example, table on provider 1 2 2 3

On subscriber 1 2 3 3

You see difference. Then I start replication and add new data to provider, for example 1 2 2 3 4

My replication is correct, so new data has been added to subscriber 1 2 3 3 4

But I want to make full synchronization, but I can't 1 1 2 2 2 3 3 3 4 4

I see the difference in rows, which had been updated before I started replication.

parthiops commented 4 months ago

@krast-napoli by any chance did you solve this problem of non-synchronization of old data?