By what command will pglogical start full synchronization?
Hello. I have some questions about pglogical documentation. There is this text: "And finally on the subscriber node you can create the subscription which will start synchronization and replication process in the background:" Does it mean, that after creating subscription FULL synchronization will start ? If I'm right, could anybody explain me next part of documentation "pglogical.alter_subscription_synchronize(subscription_name name, truncate bool) All unsynchronized tables in all sets are synchronized in a single operation. Tables are copied and synchronized one by one. Command does not block, just initiates the action. Use pglogical.wait_for_subscription_sync_complete to wait for completion."
Why do we need this commands?
I create subscription which is in status replicating
Then I run
select pglogical.alter_subscription_synchronize('my_subscription');
But when I run
select count(id)
from
my_table;
I see different values on provider and subscriber, data which was updated on provider BEFORE creating subscription haven't been updated on subscriber