X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B5F93D1EBB6 for ; Fri, 19 Mar 2004 14:49:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 28395-02 for ; Fri, 19 Mar 2004 10:49:12 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id C0459D1E934 for ; Fri, 19 Mar 2004 10:49:07 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2JEnBAG023936; Fri, 19 Mar 2004 09:49:11 -0500 (EST) To: "Nikolay Mihaylov" Cc: pgsql-admin@postgresql.org Subject: Re: Statistics collecting problem In-reply-to: <000501c40d8b$7ecff670$c8010101@nmmm.nu> References: <000501c40d8b$7ecff670$c8010101@nmmm.nu> Comments: In-reply-to "Nikolay Mihaylov" message dated "Fri, 19 Mar 2004 10:23:44 +0200" Date: Fri, 19 Mar 2004 09:49:10 -0500 Message-ID: <23935.1079707750@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/259 X-Sequence-Number: 12828 "Nikolay Mihaylov" writes: > Statistic collector not work! > Where we do mistake. This worked before on 7.3.2: Maybe some problem binding the UDP socket for statistics gathering? Look at the first few lines of the postmaster's log to see if there's any error messages concerning stats collector startup. It seems possible also that the stats messages are being dropped due to kernel packet filtering. (In fact, that's probably the most likely theory, because I think stats_start_collector would be set false if the postmaster had detected any problems with binding the socket.) Take a look at your ipchains or iptables configuration. regards, tom lane