pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcould not bind IPv4 socket
3+ messages / 2 participants
[nested] [flat]
* could not bind IPv4 socket
@ 2008-04-29 13:53 Balaji Kasthurirangan <kasthurirangan.balaji@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Balaji Kasthurirangan @ 2008-04-29 13:53 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: could not bind IPv4 socket
@ 2008-04-29 17:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: Balaji Kasthurirangan <kasthurirangan.balaji@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2008-04-29 17:42 UTC (permalink / raw)
To: Balaji Kasthurirangan <kasthurirangan.balaji@gmail.com>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: could not bind IPv4 socket
@ 2008-05-02 04:23 Balaji Kasthurirangan <kasthurirangan.balaji@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Balaji Kasthurirangan @ 2008-05-02 04:23 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-05-02 04:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-29 13:53 could not bind IPv4 socket Balaji Kasthurirangan <kasthurirangan.balaji@gmail.com>
2008-04-29 17:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-05-02 04:23 ` Balaji Kasthurirangan <kasthurirangan.balaji@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox