Rick Morris wrote:
Hi Paul,
Thanks for responding. Unfortunately, I don't think the database
connection is the problem. The system has no trouble connecting to
PostgreSQL to add users. The message you are seeing mentions that dbmail
"could not connect to database", but that is because of the other
repeated log message "dbconnect(): PQconnectdb failed: FATAL: sorry,
too many clients already". Of course, if we have runaway process
spawning, PostgreSQL will stop allowing connections after just a few
seconds. In fact, since this is an underpowered test machine, My
max-connections is set at only 40.
I will be glad to try any other tests you suggest (gdb backtrace?). I am
very interested in the possibility of using dbmail on my production
servers.
but what is the posgresql max connections set as? I think the default
in 7.4 is fairly high, but in 7.3 it might be less than 40.
