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 |