| 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: | Whole Thread | Raw Message | 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 |