Fri Sep 9 14:54:37 PDT 2005
- Previous message: [Slony1-general] switchover
- Next message: [Slony1-general] Need to recover DB with partial data...into a master DB...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] switchover
- Next message: [Slony1-general] Need to recover DB with partial data...into a master DB...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list