X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B7C169FB2C6 for ; Fri, 15 Sep 2006 13:27:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 42442-03 for ; Fri, 15 Sep 2006 16:27:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A2CCA9FB21C for ; Fri, 15 Sep 2006 13:27:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8FGRc5t002705; Fri, 15 Sep 2006 12:27:39 -0400 (EDT) To: n.howden@eris.qinetiq.com cc: pgsql-admin@postgresql.org Subject: Re: Auto Vacuum not starting unless postgres is restarted In-reply-to: <200609151657.40122.n.howden@eris.qinetiq.com> References: <200609151657.40122.n.howden@eris.qinetiq.com> Comments: In-reply-to Nick Howden message dated "Fri, 15 Sep 2006 16:57:40 +0100" Date: Fri, 15 Sep 2006 12:27:38 -0400 Message-ID: <2704.1158337658@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/159 X-Sequence-Number: 23073 Nick Howden writes: > The firewall rules I have are : > # Postgres Statistics Collector > iptables -A INPUT -p udp \ > -i lo --sport 32779 --dport 32779 \ > -j ACCEPT > iptables -A OUTPUT -p udp \ > -o lo --sport 32779 --dport 32779 \ > -j ACCEPT > ### Apparently somebody fired up postgres, noted the UDP port number it happened to have bound to that particular time, and assumed that that was the only possibility. This is not so. If I were you I'd just drop the port-number constraints ... local loopback UDP traffic is not a major source of security threats. regards, tom lane