Re: Postmasters pile up - Mailing list pgsql-general

From scott.marlowe
Subject Re: Postmasters pile up
Date
Msg-id Pine.LNX.4.33.0402261410001.10887-100000@css120.ihs.com
Whole thread Raw
In response to Postmasters pile up  (Erwin Van de Velde <erwin.vandevelde@ua.ac.be>)
List pgsql-general
On Thu, 26 Feb 2004, Erwin Van de Velde wrote:

> Hi,
>
> I'm running snort, ulogd and samhain on my system, all using persistent db
> connections. Thereby I'm using sqlrelay for my websites (which maintains a
> connection pool: default 3 persistent connections, maximal 15).
> Although I'm now the only one using the webserver (for testing purposes only),
> the number of postmaster processes keeps growing rather fast. It starts at 21
> postmaster processes and then grows within less than a quarter to 50 and so
> on. This leads to the maximum number of connections being reached.
> Checking the connections with netstat, I can only find a few (<10) active at
> any moment. Even when I'm not using sqlrelay, the number of postmasters keeps
> growing.
> Is this a known problem? What are possible causes, and what can I do about it?

I would tend to think that SQLRelay is having / causing these problems.


pgsql-general by date:

Previous
From: "Keith Bottner"
Date:
Subject: Re: Postgres clustering?
Next
From: Edwin Pauli
Date:
Subject: Re: [PgSQL 7.4.1] Problem with subquery