From: my thi ho <mthoatbanjo@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: postgresql 8.0 beta - fail to collect statsistic
Date: Mon, 23 Aug 2004 07:33:10 -0700 (PDT)
Message-ID: <20040823143310.93307.qmail@web54104.mail.yahoo.com> (raw)
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("<myip>", &(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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mthoatbanjo@yahoo.com
Subject: Re: postgresql 8.0 beta - fail to collect statsistic
In-Reply-To: <20040823143310.93307.qmail@web54104.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox