[Pgpool-general] pgpool hangs up

[Yoshiyuki Asaba]

Hi,

From: "Max Zorloff" <zorloff at gmail.com>
Subject: Re: [Pgpool-general] pgpool hangs up
Date: Mon, 27 Aug 2007 19:17:23 +0400

> I don't think the trouble is there. Because a few days ago pgpool stopped
> receiving any connections at 5 am and did this until 11am until I  
> restarted it.
> The thing is there was no significant increase in the load at 5am.
> Then again it could be that apache php forks somehow stopped closing  
> connections.

Could you get the result of ps command?

  % ps auwwx | grep pgpool

When pgpool is idle, the result is the following text.

  ... pgpool: wait for connection request

We can get the following when pgpool accepts connection,

  ... pgpool: user database [local] idle

--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp