Yesterday the RAID failed in one of my subscriber nodes for my production database. I am in the process of restoring a pg_dumpall to the box but am uncertain what to do about Slony.
The backup was made at 3:00am or so...but the raid failure didn't occur until about 8:30am. I am assuming that once my restore is complete and I fire slony back up, that it won't have the trigger events to re-populate the missing items in the database (how could it?). Certainly its not possible that slony will analyze the tables for differences and generate new events, correct? How should I get this subscriber back in sync? Should I drop nuke all the data in the subscriber, drop the node and recreate and let it start from scratch? _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
