Skip site navigation (1) Skip section navigation (2)

Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

From: Robert Young <yayooo(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, GavinFlower <gavinflower(at)archidevsys(dot)co(dot)nz>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"
Date: 2011-10-28 14:47:14
Message-ID: CAJjz_Ngp8a7pZj5PDngpKbc+gUd2Pxum-qADOhBYuAJO93FOYQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I just migrate some services from one machine to another but database
stay there.
So, I think the most simple solution is to change “localhost” point to
the new one, so that I need no modification of client applications.
But found PG gave warnings.

On Fri, Oct 28, 2011 at 13:39, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
>
> Excerpts from Robert Young's message of vie oct 28 04:11:57 -0300 2011:
>> I am just wondering, why "localhost" entry in /etc/hosts is editable
>> and why 127.0.0.1 not fixed with loopback interface?
>> should you agree with that we should submit a patch to kernel to
>> resolve "localhost" to 127.0.0.1 statically need no entry in
>> /etc/hosts and loopback interface bind to 127.0.0.1 not changeable?
>> If your answer is NO.
>
> Maybe you can define localhost as an IPv6 address.
>
>
>> Why you give me this option to configure /etc/hosts or loopback
>> interface as well as deprive my option which hostname or IP for
>> statistics_collector to listen on?
>> Why operating system designed flexible and database system wrote in hard-coding?
>
> Are you solving a real problem here?
>
> --
> Álvaro Herrera <alvherre(at)commandprompt(dot)com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

In response to

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2011-10-28 14:54:00
Subject: Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"
Previous:From: Tom LaneDate: 2011-10-28 14:03:30
Subject: Re: Re: BUG #6264: Superuser does not have inherent Replication permission

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group