Hello Samantha, from the documentation: [...] ID = ival ID of the set to subscribe
[...]
Just try it this way:
subscribe set ( id = 1, PROVIDER = 1, receiver = 2, forward = no );
Regards,
Sascha
IZB Informatikzentrum
München - Frankfurt am Main GmbH & Co.KG
Einsteinring 17
85609 Aschheim
<http://www.izb.net/> www.izb.net
Ein Unternehmen der Sparkassen Finanzgruppe.
---------------------------------------------------------------
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.
---------------------------------------------------------------
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of the material in
this e-mail is strictly forbidden.
---------------------------------------------------------------
IZB Informatik-Zentrum München-Frankfurt
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Samantha
Surendran
Gesendet: Donnerstag, 25. Januar 2007 06:48
An: [email protected]
Betreff: [Slony1-general] Error while creating second set
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***
Spreitzer, Sascha.vcf
Description: Binary data
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
