Thanks for the proxymap tip. I will definitely look into it.
However, it probably won't do much for me, since I have user and
directory information (i.e. sensitive information) looked up, and
proxymap very clearly says not to use it for that. At least, not yet.
Though it will undoubtedly help others.
On Jun 21, 2005, at 4:30 PM, Roman Neuhauser wrote:
> # 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that
> your
> message can get through to the mailing list cleanly
>