pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

Can't launch full synchronization

Open krast-napoli opened this issue 4 years ago • 1 comments

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.

krast-napoli avatar Jan 08 '22 13:01 krast-napoli

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

parthiops avatar Jun 03 '24 17:06 parthiops