Hello, Drop the _<clustername> schema. (drop schema _<clustername>;) If needed create the plpgsql language. (createlang plpgsql <masterdbname>) Start the master node and initialize the slaves with the DB structure (pg_dump -s masterdb|psqgl -h slavehost slavedb). Start slon daemons. Initialize slon daemons with slonik config via the masterhost. Subscribe nodes for replication..
This should be the steps for a successfull rebuild. With regards, Sascha Spreitzer -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Jeff Amiel Gesendet: Freitag, 19. Januar 2007 15:15 An: [email protected] Betreff: [Slony1-general] subscriber box drive failure....recovery 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 Mit freundlichen Grüßen, Sascha Spreitzer Azubi - Fachinformatiker in Richtung Systemintegration Tel: 089-94511-8123 Fax: 089-94511-1-8123 Mobil: 0172-4649076 [EMAIL PROTECTED] IZB Informatikzentrum München - Frankfurt am Main GmbH & Co.KG Einsteinring 17 85609 Aschheim www.izb.net Ein Unternehmen der Sparkassen Finanzgruppe. --------------------------------------------------------------- Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. --------------------------------------------------------------- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. --------------------------------------------------------------- IZB Informatik-Zentrum München-Frankfurt
Spreitzer, Sascha.vcf
Description: Binary data
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
