Re: Postfix/Maildrop and too many connections issues

Поиск
Список
Период
Сортировка
Искать
От
Gregory Youngblood
Тема
Re: Postfix/Maildrop and too many connections issues
Дата
Msg-id
67D7872A-D7DD-46AB-B236-7F475A18E89B@netio.org
Ответ на
Список
Дерево обсуждения
Postfix/Maildrop and too many connections issues Sven Willenberger <sven@dmv.com>
Re: Postfix/Maildrop and too many connections issues Steve Crawford <scrawford@pinpointresearch.com>
Re: Postfix/Maildrop and too many connections issues Sven Willenberger <sven@dmv.com>
Re: Postfix/Maildrop and too many connections issues Roman Neuhauser <neuhauser@sigpipe.cz>
Re: Postfix/Maildrop and too many connections issues Sven Willenberger <sven@dmv.com>
Re: Postfix/Maildrop and too many connections issues Gregory Youngblood <pgcluster@netio.org>
ANN: PG Lightning Admin for PostgreSQL 8.x Released Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: ANN: PG Lightning Admin for PostgreSQL 8.x Released Michael Glaesemann <grzm@myrealbox.com>
Re: Postfix/Maildrop and too many connections issues Gregory Youngblood <pgcluster@netio.org>
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
>

В списке pgsql-general по дате отправления
От: Gregory Youngblood
Дата:
От: Tony Caduto
Дата:
FAQ