"Stéphane A. Schildknecht" stephane.schildknecht at postgresqlfr.org
Mon Aug 10 03:26:08 PDT 2009
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

roctaiwan a écrit :
> Node 3 has not done subscribing so Node 4 can't subscribe? But it's not under
> my control to prioritize which node should subscribing first, it's all on
> one script, I run it and it suppose to do its job isn't it?
> 
> How can I fix this issue then?

You could wait before you issue the subscribe for Node 4.

You could also check in sl_subscribe to see if node 3 is active before using it
as a provider for node 4.

Maybe sthg in your setup script :

select sub_active from _$INSTANCE.sl_subscribe where sub_receiver=${NODE[$slv]}
and sub_set=$SETID

If sub_active is true, go on, and subscribe 4 to 3.

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

iD8DBQFKf/W0A+REPKWGI0ERAn7+AJ95/5r0UFwKOhBVdUXRkc7YZgPDBQCgyAz0
IY3c7GTLpnUayRkVSERI84E=
=udET
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list