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?
-
DAP
----------------------------------------------------------------------------------
David
Parker Tazz Networks (401)
709-5130
