Hi,

I've run the daemon and got the following message when I tried to subscribe:

<stdin>:4: NOTICE:  subscribeSet:: set 1 has no tables - risk of problems -
see bug 1226
<stdin>:4: NOTICE:
http://gborg.postgresql.org/project/slony1/bugs/bugupdate.php?1226

I read "outputfile1" and found this kind of message:

ERROR  remoteListenThread_2: "select ev_origin, ev_seqno, ev_timestamp,
ev_minxid, ev_maxxid, ev_xip,        ev_type,
      ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5,
ev_data6,        ev_data7, ev_data8 from "_sql_cluster".
sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by
e.ev_origin, e.ev_seqno" - could not receive data from serv
er: Error 0

What is wrong this time? I'm really stuck here. Thanks a lot for your help.

Regards,
Steven


----- Original Message ----- 
> From: "Victoria Parsons" <victoria.parsons at streamshield.com>
> To: "Steven Prasetya" <steven.prasetya at globalmobility.net>;
> <slony1-general-bounces at gborg.postgresql.org>
> Sent: Friday, August 05, 2005 4:27 PM
> Subject: RE: [Slony1-general] Problem with Database Replication
>
>
> Do you still get this warning?
>
> stdin>:4: NOTICE:  subscribeSet:: set 1 has no tables - risk of problems
> - see bug 1226
>
> I think the set will still subscribe, this is just a warning not an
> error. You can see if a set is subscribed by looking in
> _sql_cluster.sl_subscribe on the master. There should be a single entry
> for the slave node in there.
>
> Please post the error you are seeing when you try to subscribe the set.
>
> Make sure you are running a slon daemon for each node with commands
> > slon sql_cluster "dbname=contactdb user=postgres" >> outputfile1 &
> > slon sql_cluster "dbname=contactdb_slave user=postgres" >> outputfile2
> &
>
> You can run these after the first of your scripts before you try and
> subscribe the set. The subscription will not take place until the slons
> are running. Check the output files for any errors that may give a clue
> as to what is not set up properly.
>
> Vicki