Re: Postfix/Maildrop and too many connections issues - Mailing list pgsql-general

From Roman Neuhauser
Subject Re: Postfix/Maildrop and too many connections issues
Date
Msg-id 20050621233053.GA25334@isis.sigpipe.cz
Whole thread Raw
In response to Postfix/Maildrop and too many connections issues  (Sven Willenberger <sven@dmv.com>)
Responses Re: Postfix/Maildrop and too many connections issues
Re: Postfix/Maildrop and too many connections issues
List pgsql-general
# sven@dmv.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

pgsql-general by date:

Previous
From: Sven Willenberger
Date:
Subject: Re: Postfix/Maildrop and too many connections issues
Next
From: Bruce Momjian
Date:
Subject: Re: Escape handling in strings