Re: Postfix/Maildrop and too many connections issues

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

In response to

Responses

Browse pgsql-general by date

  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