#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0

    Postgres - port not getting bound to 127.0.0.1. Could not resolve "localhost"


    Hi:

    I'm seeing the following 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.

    Please help!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    What is the value of the parameter "listen_address" in postgresql.conf?
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0
    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?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Sorry I don't know Linux/Unix

    What happens if you use:

    listen_addresses = '127.0.0.1,<host_ip>'

    You might get better answers if you post this to the Postgre mailing list: http://www.postgresql.org/community/lists/
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

IMN logo majestic logo threadwatch logo seochat tools logo