471,337 Members | 829 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

could not bind IPv4 socket: Address already in use

I'm just getting started with postgresql and things are going pretty well. However, I
seem to be having trouble connecting to my database via TCP/IP. I'm assuming that
my problems are related to the message I get at startup (using "postmaster -D data -
i"). The postmaster starts but produces this message:

LOG: could not bind IPv4 socket: Address already in use
HINT: is another postmaster already running on port 5432. If not, wait a few seconds
and retry.

Looking into this a bit it seems that the most common issue here is 5432 being
claimed by an extra postmaster or another application. However, using "ps -ef" I can
confirm that NO other postmasters are running and using "netstat -a" I can confirm
that 5432 IS free so I'm at a loss.

Oddly, postgres does claim 5432 at startup and releases it at shutdown the way I
suspect it should but I still get that message. I came across a discussion at
http://www.dbforums.com/archive/index.php/t-968701.html which seems to indicate
that the message can be ignored in which case I should look somewhere else for my
TCP/IP issues.

Has anyone else run into anything like? I'm running Postgresql 7.4.2 on SUSE 8.4.
Any thoughts are greatly appreciated.


Eric Hillmuth
GIS Systems Developer
Vermont Agency of Natural Resources
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Nov 23 '05 #1
0 4329

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Johannes Eble | last post: by
6 posts views Thread by Clarence Gardner | last post: by
4 posts views Thread by 0k | last post: by
7 posts views Thread by USUN_TO | last post: by
1 post views Thread by Jonathan Woods | last post: by
5 posts views Thread by natambu | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.