Kiyoshi Sawada <[EMAIL PROTECTED]> writes:
> On Tue, 11 Nov 2003 09:18:48 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
>> So why not? Try looking in the postmaster log for errors related to
>> stats collector startup. (pstat is irrelevant, btw.)
> LOG: could not bind socket for statistics collector: Cannot assign requested address
Hmm ... that's sure the problem, but what can we do about it? ISTM that
any non-broken system ought to be able to resolve "localhost". Actually
it's worse than that: your system resolved "localhost" and then refused
to bind to any of the IP addresses it had resolved. Look at the logic
in pgstat_init() in src/backend/postmaster/pgstat.c. I think this
suggests a misconfiguration in your system ... but if you can suggest a
more robust way of setting up that connection, I'm all ears ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
