Re: postgres 9.0 - unable to bind to localhost.
От | Gunnar \"Nick\" Bluth |
---|---|
Тема | Re: postgres 9.0 - unable to bind to localhost. |
Дата | |
Msg-id | 51098E49.9020701@pro-open.de обсуждение исходный текст |
Ответ на | Re: postgres 9.0 - unable to bind to localhost. (Strahinja Kustudić <strahinjak@nordeus.com>) |
Список | pgsql-admin |
Am 23.12.2012 12:38, schrieb Strahinja Kustudić:
Sorry for a late reply, but I had the exact same problem and it was a bug in the Red Hat RPM package upgrade script of the sudo package. This basically means the user running Postgres cannot resolve hostname localhost. Have you tried logging in as the user running Postgres and trying to resolve localhost? In RHEL/Centos you would do this with:su - postgresnslookup localhost
A late comment on this one... but I've learnt this lesson the hard way :/
If you want to know what am actual program will get, use "getent hosts <hostname/IP>", that will follow the directions in nsswitch.conf and also use an nscd, if you're running one.
So, if someone (for whatever reason) once put a line
1.2.3.4 localhost
in your /etc/hosts, the "nslookup" will return what you'd expect (i.e., hopefully ;-), but Postgres will try to open a socket on 1.2.3.4. Bang!
Apart from that:
a) nslookup is deprecated since ages, use "host" or "dig" (well, no, use "getent hosts" ;-)
b) I doubt that all DNS possible servers (M$ ones spring to mind...) will provide answers to "localhost"
Just my 2p...
-- Gunnar "Nick" Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bluth@pro-open.de __________________________________________________________________________ In 1984 mainstream users were choosing VMS over UNIX. Ten years later they are choosing Windows over UNIX. What part of that message aren't you getting? - Tom Payne
В списке pgsql-admin по дате отправления: