| From: | Peter Hausmann <peter(dot)hausmann(at)dsa-ac(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Desaster Recovery from failover using SLONY-I |
| Date: | 2007-05-30 10:57:55 |
| Message-ID: | 465D58B3.6020408@dsa-ac.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
After a node is dropped due to failover, it takes days to recover the
database, because it is build up from scratch.
We would prefer another approach:
Make an Online Backup of the Provider database.
The provider database continues writing new data and the Slony-Logs.
The Backup is restored to the failed system.
The slony cluster is dropped from the restored system
and the system is defined as Slony-subscriber.
How can we setup this system to recover from the status of the backup time?
Thank you for any hint.
--
Mit freundlichen Gruessen / With best
regards
Dipl.-Inform.
Peter Hausmann
DSA Daten- und Systemtechnik GmbH
Pascalstrasse 28
D-52076 Aachen
Germany
Phone: +49 (0) 2408 / 9492- 779
Fax: +49 (0) 2408 / 9492- 92
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2007-05-30 15:47:32 | Re: Desaster Recovery from failover using SLONY-I |
| Previous Message | Roman Chervotkin | 2007-05-30 08:00:07 | pg_dump: Error message from server: ERROR: compressed data is corrupt |