X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8C1BA9FA5E9; Tue, 30 May 2006 14:52:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 91721-01; Tue, 30 May 2006 14:52:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 38B619FADD1; Tue, 30 May 2006 14:52:39 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 8FD4756427; Tue, 30 May 2006 12:52:23 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 30 May 2006 12:52:22 -0500 Date: Tue, 30 May 2006 12:52:22 -0500 From: "Jim C. Nasby" To: "Marc G. Fournier" Cc: Magnus Hagander , Tom Lane , Michael Fuhr , pgsql-hackers@postgresql.org Subject: Re: anoncvs still slow Message-ID: <20060530175221.GU59464@pervasive.com> References: <6BCB9D8A16AC4241919521715F4D8BCEA0F9BE@algol.sollentuna.se> <20060529141211.E1114@ganymede.hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060529141211.E1114@ganymede.hub.org> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060530:scrappy@postgresql.org::ruTiYgNuTcXNl97u:000000000000000 0000000000000000000000003EpJ X-Hashcash: 1:20:060530:mha@sollentuna.net::HDHFd76t0LVb80cO:0000000000000000000 0000000000000000000000004FXt X-Hashcash: 1:20:060530:tgl@sss.pgh.pa.us::PGXoMVYVQLyovVfs:00000000000000000000 00000000000000000000000059t0 X-Hashcash: 1:20:060530:mike@fuhr.org::WQ5QLD86u8TFHCN/:00000TcY X-Hashcash: 1:20:060530:pgsql-hackers@postgresql.org::G3pMwX/kOW2SoS11:000000000 0000000000000000000000003zq9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1288 X-Sequence-Number: 84153 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. -- 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