Re: could not bind IPv4 socket

From: "Balaji Kasthurirangan" <kasthurirangan(dot)balaji(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: could not bind IPv4 socket
Date: 2008-05-02 04:23:27
Message-ID: 92db61c20805012123h42c7706fn4a197b681961c75b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Balaji Kasthurirangan" <kasthurirangan(dot)balaji(at)gmail(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Darren Reed 2008-05-02 08:59:29 Re: Bus error in postgres 8.3
Previous Message Tom Lane 2008-05-01 20:34:08 Re: COPY errors when trying to convert from 7.4.19 to 8.3.1