From: | Roman Neuhauser <neuhauser(at)sigpipe(dot)cz> |
---|---|
To: | Sven Willenberger <sven(at)dmv(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postfix/Maildrop and too many connections issues |
Date: | 2005-06-21 23:30:53 |
Message-ID: | 20050621233053.GA25334@isis.sigpipe.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
# sven(at)dmv(dot)com / 2005-06-21 15:00:12 -0400:
> We have a system set up whereby postfix and maildrop gather user info
> from a pg database (7.4.2 on FreeBSD 5.2.1) to do local mail acceptance
> and delivery. I have configured max connections at 512 but I find that
> this is not enough and I get "connection limit exceeded for
> non-superusers" errors. I see upon ps ax that there are hundreds of idle
> connections (state I).
>
> Is there any way on the server end to close these connections (the
> process is apparently for postfix and then maildrop to open a
> connection, run one select statement, and supposedly close the
> connection).
You are barking up the wrong software. See proxymap(8). (It's
mentioned in http://www.postfix.org/PGSQL_README.html)
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-06-21 23:31:38 | Re: Escape handling in strings |
Previous Message | Sven Willenberger | 2005-06-21 22:34:11 | Re: Postfix/Maildrop and too many connections issues |