Thread: could not bind IPv4 socket
Hi,
I downloaded the latest version 8.3.1 and compiled it using gmake. I followed the instructions in INSTALL file. The installation was fine and when i try to start the server i get the following error message
LOG: could not bind IPv4 socket: Can't 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
I am using FreeBSD6.1. I tried for this error message in archives, but in vain.
Out of curiosity, i looked at the code and it looks like the message is from pqcomm.c. And exactly before this error in the file, comments say that the bind might fail on older linux systems....
One thought was to change the pqcomm.c and print the errno and other related details. But this would need building the server again.
This is my first stint with PostgreSQL. Also, i had to download and install since the ports were old.
Thanks,
Balaji.
I downloaded the latest version 8.3.1 and compiled it using gmake. I followed the instructions in INSTALL file. The installation was fine and when i try to start the server i get the following error message
LOG: could not bind IPv4 socket: Can't 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
I am using FreeBSD6.1. I tried for this error message in archives, but in vain.
Out of curiosity, i looked at the code and it looks like the message is from pqcomm.c. And exactly before this error in the file, comments say that the bind might fail on older linux systems....
One thought was to change the pqcomm.c and print the errno and other related details. But this would need building the server again.
This is my first stint with PostgreSQL. Also, i had to download and install since the ports were old.
Thanks,
Balaji.
"Balaji Kasthurirangan" <kasthurirangan.balaji@gmail.com> writes: > when i try to start the server i get the following error message > LOG: could not bind IPv4 socket: Can't 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 I'm thinking you have a networking or DNS configuration problem. If you do "nslookup localhost" does it come back with "127.0.0.1"? regards, tom lane
Hi Tom,
Excellent. My system network configuration has some problem. Thanks for your response.
The issue is now solved and the steps taken
1)uncommented ip and port from the postgresql conf file in the data directory and gave
1)uncommented ip and port from the postgresql conf file in the data directory and gave
valid values of 127.0.0.1 and 5432(default)
2)did run ifconfig lo0 localhost.(setting loopback)
Though the network problem still persists(for which i shall take assistance from freebsd group), the postgresql server started and i was able to create database and connect to the server using psql.
Thanks once again for your response.
Thanks,
Balaji.
On 4/29/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Balaji Kasthurirangan" <kasthurirangan.balaji@gmail.com> writes:
> when i try to start the server i get the following error message
> LOG: could not bind IPv4 socket: Can't 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
I'm thinking you have a networking or DNS configuration problem.
If you do "nslookup localhost" does it come back with "127.0.0.1"?
regards, tom lane