"Stéphane A. Schildknecht" stephane.schildknecht at postgresqlfr.org
Thu Aug 6 00:25:27 PDT 2009
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

roctaiwan a écrit :
> after I run my cluster setup script and subscribe script it shown:
> 
> -bash-3.2$ ./subscribe_multi_slave.sh
> <stdin>:31: PGRES_FATAL_ERROR select "_contactdb_cluster".subscribeSet(1, 3,
> 4, 't');  - ERROR:  Slony-I: subscribeSet(): provider 3 is not an active
> forwarding node for replication set 1
> 
> 
> what's wrong? is this error caused by my cluster setup script or subscript
> script?

It may be that Node 3 has not finished subscribing when you subscribe Node4 on it.

> 
> I have question on this line in my subscribe.sh: subscribe set (id = 1,
> provider = 1, receiver = 4, forward = yes);
> 
> should I set forward= yes or no? also if I want to get datas from Master
> then I set provider=1 if I want my Node 4 receive datas from Node3 then I
> set provider=3 receiver=4 is that correct? 
> 

The forward option lets you use that node as a provider for another one.

IIRC, Node4 is at the end, so you don't need the forward option on it. Node1
and 3 surely need it.

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

iD8DBQFKeoVnA+REPKWGI0ERAorhAKCK//KlLiv/qS+uYTyyWklkm7ZoZQCg0OXa
LhQ5dvlYusGOs0zBujDFF6A=
=ZnlD
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list