Home / server / Questions / 218409
Accepted
xain
Asked: 2011-01-04 19:07:47 +0800 CST

Error starting postgresql server on ubuntu

  • 772

I recently stopped the postgresql database (that was working perfectly), and after a couple of days, when I try to start it, I get the errors:

2011-01-03 23:56:27 CLST LOG:  could not translate host name "localhost", service "5432" to address: Name or service not known
2011-01-03 23:56:27 CLST WARNING:  could not create listen socket for "localhost"
2011-01-03 23:56:27 CLST FATAL:  could not create any TCP/IP sockets

I'm running Ubuntu 9.1, and I'm using the usuals

/etc/init.d/postgresql-8.4 start and stop

Any hints ?

ubuntu startup postgresql

3 Answers

  1. Best Answer

    Check ownership and permissions on /etc/hosts?

    Specify 127.0.0.1 in the config to isolate the problem.

    • 6

  2. Either your /etc/hosts or /etc/nsswitch.conf are messed up, nscd, if in use, is behaving crazily, or something is busted in libc.

    • 2

  3. First, I'd simply doublecheck that I can resolve "localhost" on the machine by attempting to ping it. Then. ensure that no other service is using that port with something line "netstat -ln | grep 5432".

    pgcluster will not start if you have another service, or instance of pgsql, using the same port on the machine even if this port is on a separate network adapter. If this is the case, you could simply attempt to change the port number within your postgresql.cf file in order to get pgsql back up.

    • 1