By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,822 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,822 IT Pros & Developers. It's quick & easy.

Postmasters pile up

P: n/a
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'm using Postgresql 7.4.1-2mdk on Mandrake 9.2.

Thanks in advance,

Erwin Van de Velde
Student of University of Antwerp,
Belgium
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.