Skip site navigation (1) Skip section navigation (2)

Re: Drop set problem - pgAdmin / Slony I

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
Cc: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Drop set problem - pgAdmin / Slony I
Date: 2008-01-18 16:09:15
Message-ID: 20080118160915.GN7353@svr2.hagander.net (view raw or flat)
Thread:
Lists: pgadmin-support
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
> >> > all
> >> > > the tables from scratch when it happens.
> >> > 
> >> > Can you give us an exact step-by-step on how to make it happen?
> >> > 
> >> 
> >> I tried to subscribe a new set with a new table in it and for some
> >> reason it failed with the error mentioned. The slony logs show that
> >> slony was periodically trying to subscribe on the subscriber.
> >
> > I mean complete step-to-step, as in exactly what you click and enter. I've
> > done what is at least on the surface the same thing you have, with no
> > problems. So there must be somethign in the details.
> >
> >> Seeing as I couldn't remove it from pgAdmin, I went in and ran a
> >> slonik script to drop the set, however I didn't try to unsubscribe it
> >> with slonik first. So is there a chance it's come about from me not
> >> unsubscribing first?
> >
> > Part of it may - I don't recall offhand it the must-unsubscribe-first is a
> > rqeuirement of Slonik or just of pgAdmin.
> 
> You don't need to unsubscribe first.
> 
> The stored procedure dropSet() is perfectly happy to drop the set at
> any time.  When the event propagates, it'll happily clear out all
> traces of the set.

Ok. Good. Then I think the reason it's not supported in pgAdmin is simply
because it made the GUI simpler to require that ;-)


//Magnus

In response to

Responses

pgadmin-support by date

Next:From: Kevin FieldDate: 2008-01-21 16:57:25
Subject: multiselect bug in edit grid on win32
Previous:From: Christopher BrowneDate: 2008-01-18 16:07:27
Subject: Re: Drop set problem - pgAdmin / Slony I

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group