X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1280E5E46DD for ; Mon, 23 Aug 2004 11:33:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28822-07 for ; Mon, 23 Aug 2004 14:33:09 +0000 (GMT) Received: from web54104.mail.yahoo.com (web54104.mail.yahoo.com [206.190.37.239]) by svr1.postgresql.org (Postfix) with SMTP id B84AC5E46C1 for ; Mon, 23 Aug 2004 11:33:04 -0300 (ADT) Message-ID: <20040823143310.93307.qmail@web54104.mail.yahoo.com> Received: from [129.94.6.30] by web54104.mail.yahoo.com via HTTP; Mon, 23 Aug 2004 07:33:10 PDT Date: Mon, 23 Aug 2004 07:33:10 -0700 (PDT) From: my thi ho Subject: postgresql 8.0 beta - fail to collect statsistic To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/313 X-Sequence-Number: 7949 Hi, I got this error message: LOG: could not create IPv6 socket: Address family not supported by protocol LOG: could not bind socket for statistics collector: Cannot assign requested address LOG: disabling statistics collector for lack of working socket LOG: database system was shut down at 2004-08-24 00:07:21 EST LOG: checkpoint record is at 0/A45360 LOG: redo record is at 0/A45360; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 492; next OID: 17228 LOG: database system is ready I already have a look at pgstat.c but dun know where to fix it ( with 7.3.1 i just change the line inet_aton("127.0.0.1", &(pgStatAddr.sin_addr)); to inet_aton("", &(pgStatAddr.sin_addr)); then it works this is the config of the computer: $ uname -a Linux grieg 2.4.26-general-64G #1 SMP Tue May 18 09:31:45 EST 2004 i686 GNU/Linux Any help would be really appreciated. MT __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail