Can't launch full synchronization
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 by any chance did you solve this problem of non-synchronization of old data?