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
DSA Daten- und Systemtechnik GmbH
Phone: +49 (0) 2408 / 9492- 779
Fax: +49 (0) 2408 / 9492- 92
pgsql-admin by date
|Next:||From: Andrew Sullivan||Date: 2007-05-30 15:47:32|
|Subject: Re: Desaster Recovery from failover using SLONY-I|
|Previous:||From: Roman Chervotkin||Date: 2007-05-30 08:00:07|
|Subject: pg_dump: Error message from server: ERROR: compressed data is corrupt|