Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-25 Thread Glyn Astill
Hi chaps, I've just gone over what I was doing, however this time using slonik rather than pgAdmin. I should have done this to start with, as I really had no idea what was really going off behind the scenes. What I was doing was creating a blank table on my subscriber, where the origin had a tabl

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-18 Thread Christopher Browne
Magnus Hagander <[EMAIL PROTECTED]> writes: >> There doesn't seem to be a -1 node in the sl_listen on the origin or >> the subscriber. >> >> I've removed the second set that was still visible on the subscriber >> from the sl_set table, however I'm still getting an event in the log >> where it trie

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-18 Thread Magnus Hagander
On Fri, Jan 18, 2008 at 11:07:27AM -0500, Christopher Browne wrote: > >> > > I've had this happen before. Removing the cluster and setting it > >> > up > >> > > again resolves the problem, however once we are in a production > >> > > environment I can't go dropping the whole cluster and replicating

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-18 Thread Magnus Hagander
On Wed, Jan 16, 2008 at 04:55:12AM -0800, Glyn Astill wrote: > Hi Magnus, > > > > How do I remove this set from the subscriber? > > > > I think it's somehow scheduled up behind whatever that thing going > > for > > node -1 is looking. If you can get rid of that one from sl_listen, > > I bet > >

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-17 Thread Glyn Astill
Does anyone have any idea about this? > > How do I remove this set from the subscriber? > > I think it's somehow scheduled up behind whatever that thing >going > for > node -1 is looking. If you can get rid of that one from >sl_listen, > I bet > the set dropping will go through. > > There d

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-16 Thread Glyn Astill
Hi Magnus, > > How do I remove this set from the subscriber? > > I think it's somehow scheduled up behind whatever that thing going > for > node -1 is looking. If you can get rid of that one from sl_listen, > I bet > the set dropping will go through. > > There doesn't seem to be a -1 node in

Re: [pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-15 Thread Magnus Hagander
Glyn Astill wrote: Hi chaps, I've noticed a problem as described below with regards to adding replication sets from within pgAdmin. I originally posted on the slony I general list, and Christopher Browne suggested I ask you guys. I set up a replication cluster using the pgAdmin scripts, and

[pgadmin-support] Drop set problem - pgAdmin / Slony I

2008-01-15 Thread Glyn Astill
Hi chaps, I've noticed a problem as described below with regards to adding replication sets from within pgAdmin. I originally posted on the slony I general list, and Christopher Browne suggested I ask you guys. I set up a replication cluster using the pgAdmin scripts, and added a replication se