Skip site navigation (1) Skip section navigation (2)

Re: Postmasters pile up

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Erwin Van de Velde <erwin(dot)vandevelde(at)ua(dot)ac(dot)be>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postmasters pile up
Date: 2004-02-26 21:10:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.

In response to

pgsql-general by date

Next:From: Joe ConwayDate: 2004-02-26 21:20:00
Subject: Re: help using arrays in a function
Previous:From: Erwin Van de VeldeDate: 2004-02-26 20:57:28
Subject: Postmasters pile up

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group