By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,044 Members | 1,291 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,044 IT Pros & Developers. It's quick & easy.

Address already in Use, postgres doesnot restart

P: 13
hello,
i got a problem while restarting postgresql, i removed postmaste.pid and even the temporary sock file and while restarting postgres, i got the following error:


LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
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.
WARNING: could not create listen socket for "*"
FATAL: could not create any TCP/IP sockets

so can anyone tell me what might be the problem and the solution of it.

Thanks in advance.
Ntech
Nov 29 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
hello,
i got a problem while restarting postgresql, i removed postmaste.pid and even the temporary sock file and while restarting postgres, i got the following error:


LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
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.
WARNING: could not create listen socket for "*"
FATAL: could not create any TCP/IP sockets

so can anyone tell me what might be the problem and the solution of it.

Thanks in advance.
Ntech
What about setting listen_addresses to your current IP, does it work then?. Are you sure postgres is not running? (did you check the running processes?)
Dec 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.