Re: Runaway Instances of Postmaster

> I'm running v8.0 on Linux and am seeing the following phenomenon:
>
> With each connection, I get more and more postmasters running that
> never complete, die, or timeout. Eventually all of my memory is
> depleted and the system is severely hampered.

I have the same problem.

I don't know why I have so many.
I am running mod_perl but in the startup script which is read by httpd (apache server) I have

Apache::DBI->connect_on_init ( "DBI:Pg:dbname=web_db", "web_acct", "web_passwd", { PrintError => 1, RaiseError => 0, AutoCommit => 1});

but I should only start 5 connections and pool them.

I start with 5 of them...

1. I wonder if this an Apache::DBI issue?
2. I also wonder if there is a postgres command to clear them up without restarting the postmaster?

the longer the machine is up the more connections are 'idle'

[joe(at)www Mail]$ ps -aux | grep post
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.5/FAQ
postgres 2228 0.0 0.2 20424 3072 ? S Mar08 0:02 /usr/local/pg8.1/bin/postmaster -D web_db
postgres 2234 0.0 0.4 20560 4688 ? S Mar08 0:00 postgres: writer process
postgres 2235 0.0 0.2 11212 2580 ? S Mar08 0:00 postgres: stats buffer process
postgres 2236 0.0 0.2 10440 2252 ? S Mar08 0:00 postgres: stats collector process
postgres 17604 0.0 0.4 20840 4216 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 17606 0.0 0.4 20840 4216 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 17610 0.0 0.4 20840 4216 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 17611 0.0 0.4 20840 4216 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 17612 0.0 0.4 20840 4216 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 17615 0.0 0.4 20840 4216 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 17741 0.0 0.9 21760 9716 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(54578) idle
postgres 17742 0.0 1.2 21216 12568 ? S Mar08 0:01 postgres: web_acct web_db [local] idle
postgres 17866 0.0 0.7 21828 7748 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(42312) idle
postgres 17867 0.0 1.2 21208 12584 ? S Mar08 0:01 postgres: web_acct web_db [local] idle
postgres 17932 0.0 1.0 21756 11148 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(42332) idle
postgres 17933 0.0 1.2 21208 12616 ? S Mar08 0:02 postgres: web_acct web_db [local] idle
postgres 17946 0.0 0.7 21292 7960 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(42340) idle
postgres 17947 0.0 1.2 21208 12636 ? S Mar08 0:02 postgres: web_acct web_db [local] idle
postgres 18291 0.0 0.4 20840 4216 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 18743 0.0 0.9 21768 10104 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(50653) idle
postgres 18744 0.0 1.2 21236 12592 ? S Mar08 0:01 postgres: web_acct web_db [local] idle
postgres 18832 0.0 0.8 21244 8408 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(45343) idle
postgres 18833 0.0 1.2 21208 12592 ? S Mar08 0:01 postgres: web_acct web_db [local] idle
postgres 19079 0.0 0.4 20840 4212 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 19080 0.0 0.8 21828 8420 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(42410) idle
postgres 19081 0.0 1.2 21216 12584 ? S Mar08 0:02 postgres: web_acct web_db [local] idle
postgres 19283 0.0 0.8 21824 8656 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(33292) idle
postgres 19284 0.0 1.2 21216 12556 ? S Mar08 0:01 postgres: web_acct web_db [local] idle
postgres 23309 0.0 0.4 20840 4224 ? S Mar08 0:00 postgres: web_acct web_db [local] idle
postgres 23412 0.0 0.7 21316 8160 ? S Mar08 0:00 postgres: web_acct web_db 127.0.0.1(39644) idle
postgres 23513 0.0 1.2 21208 12636 ? S Mar08 0:01 postgres: web_acct web_db [local] idle
postgres 6888 0.0 0.4 20840 4224 ? S 07:59 0:00 postgres: web_acct web_db [local] idle
postgres 7154 0.0 0.6 21232 6320 ? S 08:12 0:00 postgres: web_acct web_db 127.0.0.1(38491) idle
postgres 7155 0.0 1.0 21208 10888 ? S 08:12 0:00 postgres: web_acct web_db [local] idle
joe 10651 0.0 0.0 4856 740 pts/1 R+ 10:43 0:00 grep post
[joe(at)www Mail]$

--
joe speigle
www.sirfsup.com