Re: localhost redux - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: localhost redux
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D160@m0114.s-mxs.net
Whole thread Raw
In response to localhost redux  ("Gavin M. Roy" <gmr@ehpg.net>)
List pgsql-hackers
> 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 resolve localhost (this might
be common for Windows nameservers). I do not have a services entry for 5432,
and don't have a dns record for this RS6000.

LOG:  could not translate service "5432" to address: Host not found
WARNING:  could not create listen socket for "*"
LOG:  could not bind socket for statistics collector: Can't assign requested address

Setting to a port, that is listed in /etc/services does not change anything
(except the port of course).

I do not have those problems on a machine where dns lists the machine and localhost.
This machine has a long obsolete oslevel 4.3.2, so am not sure it is worth pursuing
the issue. I only wanted to state, that it does not work here under certain cirumstances
eighter.

Andreas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_config
Next
From: "Gavin M. Roy"
Date:
Subject: Re: localhost redux