Product:
Search Type:

Postgres cannot be started. "Address already in use" error appears in the log.

Article ID: 763 
Last Review: Sep,06 2007
APPLIES TO:
  • Plesk for Linux/Unix

RESOLUTION

First of all make sure that Postgres is not running:

ps ax | grep postmaster



Check Postgres log (by default logs stored in /var/log/pgsql, on Fedora Core /var/lib/pgsql). If you see the error like:

postmaster: cannot create UNIX stream port
LOG: StreamServerPort: bind() failed: Address already in use
Is another postmaster already running on port 5432?
If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.

This socket should be deleted:

rm -f /tmp/.s.PGSQL.5432


Try to start Postgres again. If it doesn't help look into the logs for new errors.


Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields