Fri Jan 19 06:15:05 PST 2007
- Previous message: [Slony1-general] slony replication lag and pgpool
- Next message: [Slony1-general] subscriber box drive failure....recovery
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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?
- Previous message: [Slony1-general] slony replication lag and pgpool
- Next message: [Slony1-general] subscriber box drive failure....recovery
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list