Hi Sascha,

I have created a set with set id as 2. And hence I have used the same
set ID in the subscribe set command. Before this I created a set with
set ID 1 and subcribed to it successfully.

I am creating a second set because I want to add a new table to the
replication set and I am facing problems with subcribing to the set.

Has anyone else faced this problem? Could you please help?

Thanks


Message: 2
Date: Thu, 25 Jan 2007 09:53:01 +0100
From: Sascha.Spreitzer at izb.de
Subject: Re: [Slony1-general] Error while creating second set
To: slony1-general at gborg.postgresql.org
Message-ID: <914FC41646BED511A1E40002A587EA360AD586F4 at M0000S0F>
Content-Type: text/plain; charset="iso-8859-1"

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: slony1-general-bounces at gborg.postgresql.org
[mailto:slony1-general-bounces at gborg.postgresql.org] Im Auftrag von
Samantha Surendran
Gesendet: Donnerstag, 25. Januar 2007 06:48
An: slony1-general at gborg.postgresql.org
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***
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://gborg.postgresql.org/pipermail/slony1-general/attachments/2007012
5/f10a091f/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Spreitzer, Sascha.vcf
Type: application/octet-stream
Size: 366 bytes
Desc: not available
Url :
http://gborg.postgresql.org/pipermail/slony1-general/attachments/2007012
5/f10a091f/attachment.obj 

------------------------------

_______________________________________________
Slony1-general mailing list
Slony1-general at gborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/slony1-general


End of Slony1-general Digest, Vol 36, Issue 15
**********************************************