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***_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
