Re: anoncvs still slow

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: anoncvs still slow
Дата
Msg-id 20060530230202.GW59464@pervasive.com
обсуждение исходный текст
Ответ на Re: anoncvs still slow  ("Marc G. Fournier" <scrappy@postgresql.org>)
Ответы Re: anoncvs still slow  ("Marc G. Fournier" <scrappy@postgresql.org>)
Список pgsql-hackers
On Tue, May 30, 2006 at 04:21:46PM -0300, Marc G. Fournier wrote:
> On Tue, 30 May 2006, Jim C. Nasby wrote:
> 
> >On Mon, May 29, 2006 at 02:14:42PM -0300, Marc G. Fournier wrote:
> >>On Sun, 28 May 2006, Magnus Hagander wrote:
> >>
> >>>AFAICS, this is caused by the machine attempting to relay thousands and
> >>>thousands of spam emails (some quick checked showed a rate of about 1
> >>>spam / 5 seconds enytering the queue - and I know I deleted almost
> >>>20,000 from the queue)
> >>
> >>And how exactly would you like me to fix *that*?  The reason those were in
> >>the queue is because svr4 is a legit MX record for the mailing lists ...
> >>the messages are being delivered into svr4's mail queue, and
> >>mail.postgresql.org subsequently refusing htem because they are for
> >>invalid addresses ...
> >>
> >>If I remove svr4 as an MX record, its just going to move to a different
> >>machine ...
> >>
> >>So, how exactly would you like me to "fix" that problem?
> >
> >Postfix allows you to specify a list of valid email addresses. It should
> >be a simple matter of specifying what all the valid mailing list email
> >addresses are.
> 
> The list of email addresses changes over time ... so whomever creates a 
> new mailbox would need to remember to add it on the MX servers as well ...

Depending on what the exact setup is, a friend has a script that should
help: http://slacker.com/~nugget/projects/postfixrelaymaps/

In a nutshell, it pulls from things like /etc/passwd on the master MX
and then pushes that info out to the slaves. It's written in perl, so it
should be easy to modify to pull from whatever source is necessary.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: error-free disabling of individual child partition
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: anoncvs still slow