From: | "Rajagopalan, Jayashree" <Jayashree(dot)Rajagopalan(at)emc(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | postgres 9.0 - unable to bind to localhost. |
Date: | 2012-12-10 08:57:46 |
Message-ID: | 672B315321EBEC4CA4B5627D112E0896067F53F7E4@MX25A.corp.emc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all:
Getting this error in the postgres logs:
2012-11-29 09:47:39.335 CST - SessionId:50b7839b.4791 - TransId:0 - LOG: could not translate host name "localhost", service "5435" to address: Name or service not known
2012-11-29 09:47:39.336 CST - SessionId:50b7839b.4791 - TransId:0 - WARNING: could not create listen socket for "localhost"
2012-11-29 09:47:39.343 CST - SessionId:50b7839b.4791 - TransId:0 - LOG: could not resolve "localhost": Name or service not known
Also the netstat command reveals the port(5435) is not bound to 127.0.0.1.
Checked the pg_hba.conf, /etc/hosts, nsswitch.conf, resolv.conf do not see any issues there.
the listen_addresses entry is like this:
listen_addresses = 'localhost,<host_ip>'
The port is bound to the <host_ip> but not to localhost.
How does postgres resolve the local host?
The entry is proper for localhost in /etc/hosts, and nsswitch.conf points hosts to files, dns.
"host localhost" resolves to 127.0.0.1 in command line.
what else to check?
Regards
J
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Sawyers | 2012-12-11 16:11:08 | Massive table bloat |
Previous Message | Terry Khatri | 2012-12-10 08:05:57 | Re: Setting up High Availability Group of PostgreSQL instances using RedHat Cluster Suite |