-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nagaraja, Madhukar (Madhukar) a écrit :
> Hello,
> 
> I am using slony presently on a 2 node system on a WAN.. One master and other slave.
> If for somereason the master is not reachable(link down or node down).. Then if I issue a switchover in the slave it will fail bcos it cannot connect to the postgresql on the other side. If I don't want to wait till the other node comes up, then what are the options I have. I did the failover but the process of adding back  the failed node to the cluster will not be easy and right now I don't want to use this option. So is there any way I can handle this scenario.
> 
> Can someone please respond as we have demo coming up shortly ?
> 

Hi,

If master node is unreachable, you can't switchover. You have to failover.
Which mean you have to recreate the node once link is up again.

If it's a temporary link breakage, you should wait until it comes back. It's
surely less work to do to switch than to fail.

Regards,
- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ5tBeA+REPKWGI0ERAgv9AKCLINwtLBQr4hcDzPfMVdnWkNZ1nwCeKyjK
jbdeSdqceS8GfPPyfRto8fY=
=jUPf
-----END PGP SIGNATURE-----