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 of localhost.

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'd be happy to write a patch that follows this behavior but 
wanted to see if everyone agrees with that line of thinking before doing so.

Gavin



Mon, 19 Jul 2004 16:09:40 -0700
"Gavin M. Roy" <gmr@ehpg.net>
localhost redux
"Gavin M. Roy" <gmr@ehpg.net> 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 and change pgstat to use 127.0.0.1 
> instead of localhost.

> 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
your system just misconfigured or is there some fundamental issue that
we really ought to answer to?

			regards, tom lane

Mon, 19 Jul 2004 20:31:18 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: localhost redux 
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" <gmr@ehpg.net> 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 and change pgstat to use 127.0.0.1 
>>instead of localhost.
>>    
>>
>
>  
>
>>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
>your system just misconfigured or is there some fundamental issue that
>we really ought to answer to?
>
>			regards, tom lane
>  
>


Mon, 19 Jul 2004 17:36:44 -0700
"Gavin M. Roy" <gmr@ehpg.net>
Re: localhost redux
"Gavin M. Roy" <gmr@ehpg.net> 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 ...

			regards, tom lane

Mon, 19 Jul 2004 22:02:32 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: localhost redux 
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 "on" in the
configuration file but was shown as "off" with a SHOW stats_start_collector
inside a psql section.

That GUC variable is resetted to off is the collector doesn't start ?


Regards
Gaetano Mendola






Tue, 20 Jul 2004 11:49:31 +0200
Gaetano Mendola <mendola@bigfoot.com>
Re: localhost redux
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 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 "on" in the
> configuration file but was shown as "off" with a SHOW 
> stats_start_collector
> inside a psql section.
>
> That GUC variable is resetted to off is the collector doesn't start ?
>
>
> Regards
> Gaetano Mendola
>
>
>
>
>


Tue, 20 Jul 2004 08:39:15 -0700
"Gavin M. Roy" <gmr@ehpg.net>
Re: localhost redux