Content-Type: text/plain; charset=UTF-8
Cc: Greg Sabino Mullane <greg@turnstep.com>, w^3 <pgsql-www@postgresql.org>
Subject: Re: Stopping link spam on the lists
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
In-reply-to: <16170.1333746317@sss.pgh.pa.us>
References: <9b3dc19eca1384479d9f806e2233e2f4@biglumber.com>
	<16170.1333746317@sss.pgh.pa.us>
Date: Fri, 06 Apr 2012 22:09:15 -0300
Message-Id: <1333760608-sup-6258@alvh.no-ip.org>
User-Agent: Sup/git
Content-Transfer-Encoding: quoted-printable


Excerpts from Tom Lane's message of vie abr 06 18:05:17 -0300 2012:
> "Greg Sabino Mullane" <greg@turnstep.com> writes:
> >> And another thing I'd be in favor of is forcibly unsubscribing any
> >> account seen to have sent one of these.
>=20
> > +1, but I wonder if that matters - are these compromised accounts,=20
> > or simply throwaway ones?
>=20
> Does it matter?  As long as they're spamming us more than once --- and
> they are --- zapping them would be worth doing, I think.

I always immediately unregister (which is to say, unsubscribe from all
lists and remove access to postgresql.org's Majordomo) any account from
which I see one of these link spam messages.  The thing is, I'm not
subscribed to all lists, and I don't even read all those that I am
subscribed to.  So many of these messages are passing unseen by me, and
the accounts are not unsubscribed until later.

As far as I see these accounts are all inactive accounts that subscribed
many years ago but are no longer receiving any list.  This is common in
Yahoo accounts because they tend to cause a lot of bounces and so are
unsubscribed by Majordomo automatically.

The idea of moderating emails with a high spam score is probably worth
trying out.  I'll have to research a bit how it's done though.

--=20
=C3=81lvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support