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: slony1-general-bounces at gborg.postgresql.org
[mailto:slony1-general-bounces at gborg.postgresql.org] Im Auftrag von Jeff
Amiel
Gesendet: Freitag, 19. Januar 2007 15:15
An: slony1-general at gborg.postgresql.org
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
Slony1-general at gborg.postgresql.org
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
sascha.spreitzer at izb.de


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



-------------- next part --------------
A non-text attachment was scrubbed...
Name: Spreitzer, Sascha.vcf
Type: application/octet-stream
Size: 366 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20070119/45c11120/attachment.obj