PostgreSQL list serve output has not been connecting from
mail.postgresql.org for a LONG time (see the headers below). Currently
they've been connecting from various hosts at the hub.org domain, but
there have several other non-postgresql.org connecting domains in the
past. Whenever I stop getting PostgreSQL mail, I go check my Postfix
logs to see what the new hostname's domain is, and update my whitelist.
While mail may originally come from a postgresql.org host, as I'm sure
you know, the only information that a receiving SMTP server can trust is
the connecting IP address and the hostname from a DNS reverse IP
lookup. Everything else can be falsified. That's why virtually all
SMTP-level spam filtering (including all DNS blacklist lookups) is based
on the connecting IP address.
-- Dean
-------- Original Message --------
Return-Path: <[EMAIL PROTECTED]>
X-Original-To: ***
Delivered-To: ***
Received: from mail.mailpen.net (mail.mailpen.net [209.90.228.14]) by
sc440a.internal.mailpen.net (Postfix) with ESMTP id 384105444E9 for
<***>; Mon, 11 Feb 2008 00:56:14 -0800 (PST)
Received: by mail.mailpen.net (Postfix) id D33062FE81D; Mon, 11 Feb
2008 00:56:13 -0800 (PST)
Delivered-To: ***
Received: from maia-1.hub.org (maia-1.hub.org [200.46.204.191]) by
mail.mailpen.net (Postfix) with ESMTP id 952632FE802 for <***>; Mon, 11
Feb 2008 00:56:11 -0800 (PST)
Received: from postgresql.org (postgresql.org [200.46.204.71]) by
maia-1.hub.org (Postfix) with ESMTP id 6734DDB3A14; Mon, 11 Feb 2008
04:56:07 -0400 (AST)
Received: from localhost (unknown [200.46.204.184]) by postgresql.org
(Postfix) with ESMTP id 14BEC2E030B for
<[EMAIL PROTECTED]>; Mon, 11 Feb 2008 04:54:09
-0400 (AST)
Received: from postgresql.org ([200.46.204.71]) by localhost
(mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id
80826-05 for <[EMAIL PROTECTED]>; Mon, 11 Feb 2008
04:54:01 -0400 (AST)
Received: from wx-out-0506.google.com (wx-out-0506.google.com
[66.249.82.231]) by postgresql.org (Postfix) with ESMTP id 108552E0306
for <pgsql-sql@postgresql.org>; Mon, 11 Feb 2008 04:54:04 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id r21so3723208wxc.28 for
<pgsql-sql@postgresql.org>; Mon, 11 Feb 2008 00:54:04 -0800 (PST)
Received: by 10.151.144.4 with SMTP id w4mr905002ybn.199.1202720044201;
Mon, 11 Feb 2008 00:54:04 -0800 (PST)
Received: by 10.150.96.5 with HTTP; Mon, 11 Feb 2008 00:54:04 -0800 (PST)
Message-ID: <[EMAIL PROTECTED]>
Date: Mon, 11 Feb 2008 08:54:04 +0000
From: Dave Page <***>
To: Dean Gibson (DB Administrator) <***>
Subject: Re: [SQL] Bouncing replies
Cc: pgsql-sql@postgresql.org
In-Reply-To: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Mailing-List: pgsql-sql
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:[EMAIL PROTECTED]>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
Precedence: bulk
Sender: [EMAIL PROTECTED]
Status: O
X-UID: 25516
Content-Length: 1252
X-Keywords:
On Feb 11, 2008 5:06 AM, Dean Gibson (DB Administrator) wrote:
If mail to my list address doesn't come from one of your list
servers (and those seems to change much more often than any other list I
belong to), it gets rejected.
Those must be some *really* long-lived lists. Our mailserver has been
mail.postgresql.org for probably 7 or 8 years now. Many moons ago we
did use some additional relay servers, but I don't think we've done
that for 5+ years.
