Hi,

I am trying to create a second set and then do a merge onto the first
one.
The create set and set add table went through fine. But the subscribe
set failed.


this is my script, which contains only the subcribe set

#/bin/bash

slonik <<_EOF_ 2>> /usr/local/pgsql/slony_setup.log 1>>
/usr/local/pgsql/slony_setup.log
        cluster name = was1_;
    node 1 admin conninfo = 'dbname=wasdb3 host=xxxx port=5432
user=postgres password=xyz';
        node 2 admin conninfo = 'dbname=wasdb3 host=yyyy port=5432
user=postgres password=xyz';

        subscribe set ( id = 2, PROVIDER = 1, receiver = 2, forward = no
);
_EOF_

if [ $? -ne 0 ]
then
    echo Errors were detected.  Please review
/usr/local/pgsql/slony_setup.log and fix the errors.
    exit -1
fi

echo The script has succeeded.  At this time the slaves should be
receiving the data
echo from the master.


I still receive this error on running this script.
<stdin>:5: PGRES_FATAL_ERROR select "_was1_".subscribeSet(2, 1, 2, 'f');
- ERROR:  Slony-I: set 2 not found

Has anyone faced this error before. Can someone please help?


Regards,
Samantha



**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20070125/c9dc2620/attachment-0001.html