Hi,
I am trying to explore Pglogical to migrate the database from one host to other and I have some questions.
1.How do the Pglogical handle if provider or subscriber is down for a significant time? Does it synch up automatically once the Db is up on both the nodes?
2.I have a very big table(around 800GB) that needs to be migrated using Pglogical, does it generates a lot of WAL on provider, and how to handle the situation going out of control.
3.Can we restore the database using pg dump or some other means on the subscriber node and after restore can we start Pglogical replication ? Does it synch the tables fast this way as most of the data is already there on subscribers?
Appreciate any points.
Thanks,
Kumar