Josh Harrison joshques at gmail.com
Wed Dec 12 08:59:47 PST 2007
Hi,
Im trying slony for the first time....
Slon is running in both master and slave. For replication I execute this
script

#!/bin/sh
    slonik <<_EOF_
    	 # ----
    	 # This defines which namespace the replication system uses
    	 # ----
    	 cluster name =3D $CLUSTERNAME;

    	 # ----
    	 # Admin conninfo's are used by the slonik program to connect
    	 # to the node databases.  So these are the PQconnectdb arguments
    	 # that connect from the administrators workstation (where
    	 # slonik is executed).
    	 # ----
    	 node 1 admin conninfo =3D 'dbname=3D$MASTERDBNAME host=3D$MASTERHOST
user=3D$REPLICATIONUSER';
    	 node 2 admin conninfo =3D 'dbname=3D$SLAVEDBNAME host=3D$SLAVEHOST
user=3D$REPLICATIONUSER';

    	 # ----
    	 # Node 2 subscribes set 1
    	 # ----
    	 subscribe set ( id =3D 1, provider =3D 1, receiver =3D 2, forward =3D=
 no);
    _EOF_

And when i run this script I get this error...
PGRES_FATAL_ERROR select "_slony_example".subscribeSet(1, 1, 2, 'f');  -
sERROR:  Slony-I: subscribeSet(): set 1 not found

What is wrong here?
Thanks
josh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071212/=
4cdcae34/attachment.htm


More information about the Slony1-general mailing list