Okay, thats what I figured. Perhaps when you ran that script against the slave also, you somehow overwrote the first, correct subscription? Seems like somehow you may have subscribed a table to itself, which would, of course, not work so well. I would also check your listen path descriptions:
http://www.slony.info/documentation/listenpaths.html and make sure they are properly configured. /kurt On Aug 30, 2007, at 8:14 AM, Benezra, Eric wrote: > Sorry for the confusing wording. What I meant was that, on the Master, > under subscriptions, the table is there (along with a subscription to > the slave node). > > On the Slave node, there is a subscription also but also to the Slave > node (to itself?) and no table present. So I was just wondering if it > had something to do with my replication script or possibly something > with the communication between the two machines > > > > > -----Original Message----- > From: Kurt Overberg [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 29, 2007 8:15 PM > To: Benezra, Eric > Subject: Re: [Slony1-general] Question about replication script > > Someone please correct me if I'm wrong, but you should only have to > run > this script once, generally against the master (I believe is the > convention, but I don't think it matters). I'm not sure what you mean > when you say the table appears on the slave, then you later say > that the > table does not appear on the slave? > > Hope this helps... > > /kurt > > Kurt Overberg [EMAIL PROTECTED] _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
