"Stéphane A. Schildknecht" stephane.schildknecht at postgresql.fr
Tue Jan 4 06:46:01 PST 2011
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 04/01/2011 15:39, Steve Singer a écrit :
> On 11-01-04 09:15 AM, Devrim GÜNDÜZ wrote:
>>
>> We changed network topology in one of our clusters, and I need to renew
>> IP addresses in both origin and master.
>>
>> How can I do that without restarting replication from scratch? In this
>> case, the data is small, and I can restart replication -- but still I
>> wonder whether there is a better way to do that or not.
>>
> 
> I think you can do this by
> 
> 1) Issuing a series of STORE PATH commands to update all of your 
> conninfo tables to have the new IP
> 
> 2) Restart the slon daemons to have the new IP in the conninfo for the 
> local node (update the command line or slon.conf to have the new I.P)
> 
> 3) Update any admin conninfo lines in any slonik scripts/preambles you 
> have lying around
> 
> Slony doesn't store the nodes IP as part of sl_node.
> 
> 

Hi,

Having done such things recently, I can warn you to wait long enough to be sure
the event of modifying the path is correctly propagated.
It's not really long, though, but don't issue the store path and the restart in
the same breath.

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

iEYEARECAAYFAk0jMqkACgkQA+REPKWGI0GC6ACgtn2nkzOPw75cAguY+rt/ICQ4
ZxUAoLBWoTYQuGSzsaymaTQW04xDZl5+
=oHeN
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list