Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 985A663240A for ; Mon, 2 Aug 2010 07:36:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 58215-05 for ; Mon, 2 Aug 2010 10:36:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from rs73.luxsci.com (rs73.luxsci.com [64.49.254.135]) by mail.postgresql.org (Postfix) with ESMTP id D72296323CD for ; Mon, 2 Aug 2010 07:36:04 -0300 (ADT) Received: from GNANAM (ABTS-TN-Static-186.58.165.122.airtelbroadband.in [122.165.58.186] (may be forged)) (authenticated bits=0) by rs73.luxsci.com (8.13.8/8.13.8) with ESMTP id o72AZxBA003183; Mon, 2 Aug 2010 05:36:01 -0500 Reply-To: From: "Gnanakumar" To: "'Kevin Grittner'" Cc: References: <4BC1C70102000025000306DD@gw.wicourts.gov> In-Reply-To: <4BC1C70102000025000306DD@gw.wicourts.gov> Subject: Re: Statistics Collector not collecting server activities Date: Mon, 2 Aug 2010 16:05:56 +0530 Organization: Zoniac Software Private Limited Message-ID: <000601cb322e$804dae10$80e90a30$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcrZoFNbQHoHl4bfSN6GlkHNILWxMBYjHOmg Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201008/7 X-Sequence-Number: 35256 >> Does stats collector process need any other special >> resource/privilege/operations/port to start? > If I understand correctly, it uses UDP. I don't think PostgreSQL > uses UDP outside of that. Still I'm not able to resolve/fix this statistics collector (not starting/working) in one of our customer production server and because of this autovacuum daemon is also not able to perform its job effectively, thereby it is indirectly impacting on the disk space growth. There are no anti-virus program running, no SE-Linux, etc. I've pasted below my "/etc/sysconfig/iptables" to reveal my firewall rules. Does PostgreSQL establish working UDP sockets on some specific defined port or it chooses the port randomly? Looking at experts guidance to resolve my issue. ================================= [root@dbserver ~]# more /etc/sysconfig/iptables # Generated by iptables-save v1.3.5 on Mon Sep 14 20:04:30 2009 *nat :PREROUTING ACCEPT [10934:1556118] :POSTROUTING ACCEPT [0:0] :OUTPUT ACCEPT [111392:6686084] -A PREROUTING -p tcp -m tcp --dport 80 -j REDIRECT --to-ports 5050 -A POSTROUTING -j MASQUERADE -A OUTPUT -d 192.168.0.200 -p tcp -m tcp --dport 80 -j DNAT --to-destination 192.168.0.200:5050 -A OUTPUT -d 127.0.0.1 -p tcp -m tcp --dport 80 -j DNAT --to-destination 127.0.0.1:5050 COMMIT # Completed on Mon Sep 14 20:04:30 2009 # Generated by iptables-save v1.3.5 on Mon Sep 14 20:04:30 2009 *filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [0:0] -A INPUT -j ACCEPT -A FORWARD -j ACCEPT -A OUTPUT -j ACCEPT COMMIT # Completed on Mon Sep 14 20:04:30 2009 =================================