Re: PGSTAT: bind(2): Can't assign requested address

Well, you are the first to report that 127.0.0.1 doesn't work for stats.
Unless someone else has a problem, I think we will leave it unchanged.

---------------------------------------------------------------------------

Bjoern A. Zeeb wrote:
> PRIO: low
>
> Hi,
>
> in src/backend/postmaster/pgstat.c there is a hard coded bind to
> 127.0.0.1 that fails if 127.0.0.1 is not configured on loopback
> interface (e.g. administrator explicitly removed this IP).
> This should _not_ be the case in normal setups.
>
> --- gmake check ---
> ...
> ============== creating temporary installation ==============
> ============== initializing database system ==============
> ============== starting postmaster ==============
>
> pg_regress: postmaster did not start
> Examine ./log/postmaster.log for the reason.
>
> kill: 97857: No such process
> rm regress.o
> gmake[2]: Leaving directory `/u1/local/src/postgresql/postgresql-7.2.1/src/test/regress'
> gmake[1]: Leaving directory `/u1/local/src/postgresql/postgresql-7.2.1/src/test'
> % cat src/test/regress/log/postmaster.log
> PGSTAT: bind(2): Can't assign requested address
> --- snipp ---
>
> With postgresql-7.2.1 (and perhaps also earlier versions ?) this
> prevents postmaster from starting if one does not configure
> 'stats_start_collector = false'.
> This works as a workaround.
> One may also patch the sources and recompile of course.
>
> I have seen that there were changes in CVS already but the 127.0.0.1 is
> still hard coded in there.
>
> I discovered that after playing with some routing daemons on my test
> machine and therefor had removed 127.0.0.1. OS was FreeBSD 4.5-STABLE
> but that shouldn't matter.
>
> --
> Greetings
>
> Bjoern A. Zeeb bzeeb at Zabbadoz dot NeT
> 56 69 73 69 74 http://www.zabbadoz.net/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026