Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E4697632961 for ; Tue, 4 May 2010 12:39:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83172-10 for ; Tue, 4 May 2010 15:39:43 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 97DD96323ED for ; Tue, 4 May 2010 12:39:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o44FdejK013336; Tue, 4 May 2010 11:39:41 -0400 (EDT) To: Peter Sabaini cc: pgsql-admin@postgresql.org Subject: Re: Statistics collector port / unix dom. socket? In-reply-to: <1272977816.21378.13.camel@w-ehs-psa.telbiomed.at> References: <1272977816.21378.13.camel@w-ehs-psa.telbiomed.at> Comments: In-reply-to Peter Sabaini message dated "Tue, 04 May 2010 14:56:56 +0200" Date: Tue, 04 May 2010 11:39:40 -0400 Message-ID: <13335.1272987580@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/40 X-Sequence-Number: 34513 Peter Sabaini writes: > it seems Postgres tries to send a UDP packet to a random high port to > communicate with the statistics collector daemon. We have rather strict > packet filter rules in place, and I'd like to make the system use a > fixed port for this, or even better a Unix domain socket. Is this > possible (setting a compile time or run time parameter)? No, the stats collector just uses whatever port bind() chooses for it. I'd suggest backing off your ideas about how much filtering is appropriate for local connections. regards, tom lane