Philip Warner pjw
Fri Sep 9 14:54:37 PDT 2005
Sorry to be asking this question (in more ways than one), but we were
recently evaluating slony for our replication needs when our db server
died....good timing apart from the fact the we had killed the 'slon'
replication processes about a week ago.

The loss was fairly catastrophic, meaning 90% of our data was lost and
the DB disk is completely dead, but we do have partial backups of the DB
-- including the slony schema and data from the still-installed slony
triggers.

We also still had the old slave DB which we were able to 'failover' to
using slony. We did not replicate sequences, but we've bumped them up a
long way to avoid possible overlap with any data we do recover.

My question is: is there as way I can just restore the slony tables then
make slony apply those changes to the current master? Or generate a
script to do this? If the old master was still around, we should be able
to apply the changes to the old slave, but the old master is gone, and
the old slave is now a master.

Ideally, I'd like to just apply changes to a subset of the old tables:
looking at the data in the slony schema, it seems all I need is there...

Any help or suggestions would be appreciated.









More information about the Slony1-general mailing list