Re: pg_listener records - Mailing list pgsql-general

From Scott Marlowe
Subject Re: pg_listener records
Date
Msg-id 1117133460.31821.347.camel@state.g2switchworks.com
Whole thread Raw
In response to pg_listener records  ("David Parker" <dparker@tazznetworks.com>)
List pgsql-general
On Thu, 2005-05-26 at 13:41, David Parker wrote:
> In failover testing we have been doing recently (postgres 7.4.5 w/
> slony 1.0.2) we have seen several times when the database comes back
> up after a power failure it still has old pg_listener records hanging
> around from its previous life. This causes some problems with slony,
> but of course it is easy enough to implement a procedure to clean
> those records out, which we have done.
>
> But I'm wondering - shouldn't that be part of normal server startup,
> cleaning out the pg_listener table? Or has this been addressed in
> 8.X.? Or is there a reason this isn't a good idea?

You should really be running the latest version of slony, 1.0.5.  There
were plenty of little niggling bugs in the earlier version that have
been fixed.  I'd upgrade postgresql while I was at it too, but slony
DEFINITELY needs to be the latest version.

I'm pretty sure the problem you speak of was in fact fixed in later
versions, btw.

pgsql-general by date:

Previous
From: "David Parker"
Date:
Subject: pg_listener records
Next
From: "David Parker"
Date:
Subject: Re: pg_listener records