| From: | Dharmendra K <dharmendra(dot)sql(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | pglogical question |
| Date: | 2021-07-20 15:20:24 |
| Message-ID: | CADGwYGVUuOp+tuu=U77TruDqAcCi6QGkSWaycXCFmA5AMXHxAA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vijaykumar Jain | 2021-07-20 16:50:51 | Re: pglogical question |
| Previous Message | Holger Jakobs | 2021-07-20 08:01:41 | Re: postgresql.auto.conf |