[GENERAL] pg_listener records

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[GENERAL] pg_listener records

David Parker
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
 

 
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] pg_listener records

Scott Marlowe
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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] pg_listener records

David Parker
In reply to this post by David Parker
Thanks. Yeah, I know slony 1.0.5 cleans up after itself, and is better
in general, and I want to get there, but upgrading is not an option at
the moment, unfortunately. Same for postgres 8.

But it still seems like this is something the server itself should be
taking care of, not a client process....

- DAP

>-----Original Message-----
>From: Scott Marlowe [mailto:[hidden email]]
>Sent: Thursday, May 26, 2005 2:51 PM
>To: David Parker
>Cc: postgres general
>Subject: Re: [GENERAL] pg_listener records
>
>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.
>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] pg_listener records

Tom Lane-2
In reply to this post by David Parker
"David Parker" <[hidden email]> writes:
> But I'm wondering - shouldn't that be part of normal server startup,
> cleaning out the pg_listener table?

Perhaps, but the code is written such that it's unlikely to be a major
problem --- notifying processes automatically clean out entries that
don't correspond to active backend PIDs.

The long-term solution to LISTEN/NOTIFY performance issues is to get rid
of the table altogether, so I don't see a lot of point in putting effort
into band-aids like cleaning out the table during restart.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] pg_listener records

Vick Khera
In reply to this post by David Parker

On May 26, 2005, at 2:41 PM, David Parker wrote:

> 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?
>

Try slony 1.0.5, which fixed *many* issues and bugs.  I believe this  
is one of them.  The upgrade should be uneventful.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org