"Stéphane A. Schildknecht" stephane.schildknecht at postgresql.fr
Mon Mar 22 02:37:18 PDT 2010
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 21/03/2010 15:37, Philippe Clérié a écrit :
> I am trying to recover from a catastrophe and I am about to do something new 
> and I need some reassurance that it's the correct procedure.
> 
> I have a Slony replication set with two nodes in a master/slave 
> configuration, Postgresql 8.1, Slony 1.2.1 on Debian Etch. Node1 (master) was 
> taken out of commission (think a rm -rf * type error). I've recovered from a 
> previous backup that's about 3 weeks out of date, but Node2 is up to date. I 
> want Node2 to update Node1 and then I want to go back to normal.

(...)

As you only have two nodes, I think you'd better drop the replication from the
2 nodes and recreate it from scratch, having node2 as provider.

Once Node1 is synced with node2, you could do a move set.

Best regards,
- --
Stéphane Schildknecht
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkunOiMACgkQA+REPKWGI0GkBwCfb607brnQatcqhvOrzJD5+QTb
BVAAoLywTeaCFZaSo1hEZWaBKZwC/iSd
=ilvp
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list