Tomeh, Husam HTomeh at facorelogic.com
Wed Dec 12 09:06:48 PST 2007
Have you created your replication set(s) before attempting to issue the
subscribe command?  The error may suggest that the set doesn't exist.
 
Regards,
 
    -  Husam

________________________________

From: slony1-general-bounces at lists.slony.info
[mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Josh
Harrison
Sent: Wednesday, December 12, 2007 9:00 AM
To: slony1-general at lists.slony.info
Subject: [Slony1-general] Slony-I: subscribeSet(): set 1 not found ERROR


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 = $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 = 'dbname=$MASTERDBNAME host=$MASTERHOST
user=$REPLICATIONUSER';

    	 node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
user=$REPLICATIONUSER';
    
    	 # ----
    	 # Node 2 subscribes set 1
    	 # ----
    	 subscribe set ( id = 1, provider = 1, receiver = 2, forward =
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




**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071212/48f60e90/attachment-0001.htm


More information about the Slony1-general mailing list