PDA

View Full Version : Problem with PostgreSQL


rensu
May 7th, 2006, 12:01 PM
Have anyone had the same problem? If yes could someone help me please:(

Getting this error after installing postgresql-8.1:
* Starting PostgreSQL 8.1 database server: main
The PostgreSQL server failed to start. Please check the log output:
LOG: could not bind IPv4 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
WARNING: could not create listen socket for "localhost"
FATAL: could not create any TCP/IP sockets
...fail!

And no there is not other postmater running on port 5432.

agile
May 10th, 2006, 09:57 AM
Ditto. I'm on the hunt for the solution now. ] (*,)

LordHunter317
May 10th, 2006, 11:02 AM
Is there something else using htat port? What does 'netstat -pln --inet --inet6' say?

agile
May 10th, 2006, 11:08 AM
AHA!

my loopback was missing! :)

double check that your /etc/network/interfaces has a loopback device configured.
mine had been moved to /etc/network/interfaces.back for some reason or another. :( mysterious.

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).

# The loopback network interface
auto lo
iface lo inet loopback

rensu
May 10th, 2006, 01:37 PM
In /etc/network/interfaces :
getting those lines:
# The loopback network interface
auto lo
iface lo inet loopback

So I guess I have the lines what you were talking about. But it's still not working for me :(