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.orgconnecting domains in the past. Whenever I stop getting PostgreSQL mail, I go check my Postfix logs
tosee what the new hostname's domain is, and update my whitelist.<br /><br /> While mail may originally come from a
postgresql.orghost, as I'm sure you know, the only information that a receiving SMTP server can trust is the connecting
IPaddress and the hostname from a DNS reverse IP lookup. Everything else can be falsified. That's why virtually all
SMTP-levelspam filtering (including all DNS blacklist lookups) is based on the connecting IP address.<br /><br /> --
Dean<br/><br /> -------- Original Message -------- <table border="0" cellpadding="0" cellspacing="0"
class="moz-email-headers-table"><tbody><tr><thalign="right" nowrap valign="baseline">Return-Path: </th><td><a
class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-owner+M30162@postgresql.org"><pgsql-sql-owner+M30162@postgresql.org></a></td></tr><tr><th
align="right"nowrap valign="baseline">X-Original-To: </th><td>***</td></tr><tr><th align="right" nowrap
valign="baseline">Delivered-To:</th><td>***</td></tr><tr><th align="right" nowrap valign="baseline">Received:
</th><td>frommail.mailpen.net (mail.mailpen.net [209.90.228.14]) by sc440a.internal.mailpen.net (Postfix) with ESMTP id
384105444E9for <***>; Mon, 11 Feb 2008 00:56:14 -0800 (PST)</td></tr><tr><th align="right" nowrap
valign="baseline">Received:</th><td>by mail.mailpen.net (Postfix) id D33062FE81D; Mon, 11 Feb 2008 00:56:13 -0800
(PST)</td></tr><tr><thalign="right" nowrap valign="baseline">Delivered-To: </th><td>***</td></tr><tr><th align="right"
nowrapvalign="baseline">Received: </th><td>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)</td></tr><tr><th
align="right"nowrap valign="baseline">Received: </th><td>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)</td></tr><tr><th align="right"
nowrapvalign="baseline">Received: </th><td>from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with
ESMTPid 14BEC2E030B for <a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-postgresql.org@postgresql.org"><pgsql-sql-postgresql.org@postgresql.org></a>;Mon, 11 Feb
200804:54:09 -0400 (AST)</td></tr><tr><th align="right" nowrap valign="baseline">Received: </th><td>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 <a
class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-postgresql.org@postgresql.org"><pgsql-sql-postgresql.org@postgresql.org></a>;Mon, 11 Feb
200804:54:01 -0400 (AST)</td></tr><tr><th align="right" nowrap valign="baseline">Received: </th><td>from
wx-out-0506.google.com(wx-out-0506.google.com [66.249.82.231]) by postgresql.org (Postfix) with ESMTP id 108552E0306
for<a class="moz-txt-link-rfc2396E" href="mailto:pgsql-sql@postgresql.org"><pgsql-sql@postgresql.org></a>; Mon,
11Feb 2008 04:54:04 -0400 (AST)</td></tr><tr><th align="right" nowrap valign="baseline">Received: </th><td>by
wx-out-0506.google.comwith SMTP id r21so3723208wxc.28 for <a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql@postgresql.org"><pgsql-sql@postgresql.org></a>;Mon, 11 Feb 2008 00:54:04 -0800
(PST)</td></tr><tr><thalign="right" nowrap valign="baseline">Received: </th><td>by 10.151.144.4 with SMTP id
w4mr905002ybn.199.1202720044201;Mon, 11 Feb 2008 00:54:04 -0800 (PST)</td></tr><tr><th align="right" nowrap
valign="baseline">Received:</th><td>by 10.150.96.5 with HTTP; Mon, 11 Feb 2008 00:54:04 -0800 (PST)</td></tr><tr><th
align="right"nowrap valign="baseline">Message-ID: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:937d27e10802110054h6538294bwcb8100665048bd57@mail.gmail.com"><937d27e10802110054h6538294bwcb8100665048bd57@mail.gmail.com></a></td></tr><tr><th
align="right"nowrap valign="baseline">Date: </th><td>Mon, 11 Feb 2008 08:54:04 +0000</td></tr><tr><th align="right"
nowrapvalign="baseline">From: </th><td>Dave Page <***></td></tr><tr><th align="right" nowrap
valign="baseline">To:</th><td>Dean Gibson (DB Administrator) <***></td></tr><tr><th align="right" nowrap
valign="baseline">Subject:</th><td>Re: [SQL] Bouncing replies</td></tr><tr><th align="right" nowrap
valign="baseline">Cc:</th><td><a class="moz-txt-link-abbreviated"
href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a></td></tr><tr><thalign="right" nowrap
valign="baseline">In-Reply-To:</th><td><a class="moz-txt-link-rfc2396E"
href="mailto:47AFD7DD.2040000@ultimeth.com"><47AFD7DD.2040000@ultimeth.com></a></td></tr><tr><thalign="right"
nowrapvalign="baseline">MIME-Version: </th><td>1.0</td></tr><tr><th align="right" nowrap
valign="baseline">Content-Type:</th><td>text/plain; charset=ISO-8859-1</td></tr><tr><th align="right" nowrap
valign="baseline">Content-Transfer-Encoding:</th><td>7bit</td></tr><tr><th align="right" nowrap
valign="baseline">Content-Disposition:</th><td>inline</td></tr><tr><th align="right" nowrap
valign="baseline">References:</th><td><a class="moz-txt-link-rfc2396E"
href="mailto:47AFA703.5060907@ultimeth.com"><47AFA703.5060907@ultimeth.com></a><a class="moz-txt-link-rfc2396E"
href="mailto:15372.1202698673@sss.pgh.pa.us"><15372.1202698673@sss.pgh.pa.us></a><a class="moz-txt-link-rfc2396E"
href="mailto:15505.1202699499@sss.pgh.pa.us"><15505.1202699499@sss.pgh.pa.us></a><a class="moz-txt-link-rfc2396E"
href="mailto:47AFD7DD.2040000@ultimeth.com"><47AFD7DD.2040000@ultimeth.com></a></td></tr><tr><thalign="right"
nowrapvalign="baseline">X-Virus-Scanned: </th><td>Maia Mailguard 1.0.1</td></tr><tr><th align="right" nowrap
valign="baseline">X-Mailing-List:</th><td>pgsql-sql</td></tr><tr><th align="right" nowrap
valign="baseline">List-Archive:</th><td><a class="moz-txt-link-rfc2396E"
href="http://archives.postgresql.org/pgsql-sql"><http://archives.postgresql.org/pgsql-sql></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-Help: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:majordomo@postgresql.org?body=help"><mailto:majordomo@postgresql.org?body=help></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-ID: </th><td><pgsql-sql.postgresql.org></td></tr><tr><th align="right"
nowrapvalign="baseline">List-Owner: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-owner@postgresql.org"><mailto:pgsql-sql-owner@postgresql.org></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-Post: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql@postgresql.org"><mailto:pgsql-sql@postgresql.org></a></td></tr><tr><thalign="right" nowrap
valign="baseline">List-Subscribe:</th><td><a class="moz-txt-link-rfc2396E"
href="mailto:majordomo@postgresql.org?body=sub%20pgsql-sql"><mailto:majordomo@postgresql.org?body=sub%20pgsql-sql></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-Unsubscribe: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql"><mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql></a></td></tr><tr><th
align="right"nowrap valign="baseline">Precedence: </th><td>bulk</td></tr><tr><th align="right" nowrap
valign="baseline">Sender:</th><td><a class="moz-txt-link-abbreviated"
href="mailto:pgsql-sql-owner@postgresql.org">pgsql-sql-owner@postgresql.org</a></td></tr><tr><thalign="right" nowrap
valign="baseline">Status:</th><td>O</td></tr><tr><th align="right" nowrap valign="baseline">X-UID:
</th><td>25516</td></tr><tr><thalign="right" nowrap valign="baseline">Content-Length: </th><td>1252</td></tr><tr><th
align="right"nowrap valign="baseline">X-Keywords: </th><td><br /></td></tr></tbody></table><br /><br /><pre>On Feb 11,
20085: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.
</pre>
