Re: [HACKERS] localhost redux

2004-07-20 Thread Zeugswetter Andreas SB SD
I don't know if the problem is isolated to just me, but I wanted to suggest that we use a parameter for that, which can be configured in the postgresql.conf, with a default value if it's not set, set to localhost. I think you should first trace down what the problem really is --- is

Re: [HACKERS] localhost redux

2004-07-20 Thread Gaetano Mendola
Gavin M. Roy wrote: I have no problem resolving localhost anywhere else on the box, do you have any suggestions on finding out if it's a misconfiguration? Gavin Are you the users on IRC yesterday night ? He had the same problem, however he/she had the GUC variable stats_start_collector equal to

Re: [HACKERS] localhost redux

2004-07-20 Thread Tom Lane
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: I think you should first trace down what the problem really is --- is your system just misconfigured or is there some fundamental issue that we really ought to answer to? The trouble on AIX is, that getaddrinfo only does a nameservice

Re: [HACKERS] localhost redux

2004-07-20 Thread Andrew Dunstan
Tom Lane wrote: Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: I think you should first trace down what the problem really is --- is your system just misconfigured or is there some fundamental issue that we really ought to answer to? The trouble on AIX is, that getaddrinfo only

Re: [HACKERS] localhost redux

2004-07-20 Thread Zeugswetter Andreas SB SD
If localhost isn't being resolved correctly are you seeing error messages like this on the server log (from pqcomm.c)? could not translate host name \%s\, service \%s\ to address: %s After poking around, I found the following: The Windows pdc (==name server :-( ) does really not

Re: [HACKERS] localhost redux

2004-07-20 Thread Gavin M. Roy
Yeah, I was talking about it on freenode yesterday. If the stats collector doesn't start, the internal variable is set to off. Gavin Gaetano Mendola wrote: Gavin M. Roy wrote: I have no problem resolving localhost anywhere else on the box, do you have any suggestions on finding out if it's a

Re: [HACKERS] localhost redux

2004-07-20 Thread Steve Atkins
On Tue, Jul 20, 2004 at 08:32:00AM -0400, Tom Lane wrote: Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: I think you should first trace down what the problem really is --- is your system just misconfigured or is there some fundamental issue that we really ought to answer to? The

[HACKERS] localhost redux

2004-07-19 Thread Gavin M. Roy
I've been having a problem with the pgstat.c localhost change since 7.4, in that statistics gathering stopped working on my gentoo boxes. I've not traced it back beyond getaddrinfo called in getaddrinfo_all, and decided the quick fix was to go back and change pgstat to use 127.0.0.1 instead

Re: [HACKERS] localhost redux

2004-07-19 Thread Tom Lane
Gavin M. Roy [EMAIL PROTECTED] writes: I've been having a problem with the pgstat.c localhost change since 7.4, in that statistics gathering stopped working on my gentoo boxes. I've not traced it back beyond getaddrinfo called in getaddrinfo_all, and decided the quick fix was to go back

Re: [HACKERS] localhost redux

2004-07-19 Thread Gavin M. Roy
I have no problem resolving localhost anywhere else on the box, do you have any suggestions on finding out if it's a misconfiguration? Gavin Tom Lane wrote: Gavin M. Roy [EMAIL PROTECTED] writes: I've been having a problem with the pgstat.c localhost change since 7.4, in that statistics

Re: [HACKERS] localhost redux

2004-07-19 Thread Tom Lane
Gavin M. Roy [EMAIL PROTECTED] writes: I have no problem resolving localhost anywhere else on the box, do you have any suggestions on finding out if it's a misconfiguration? In that case maybe we have a bug to fix; but that makes me even less eager to solve it by substituting 127.0.0.1 ...