Excellent. My system network configuration has some problem. Thanks for your
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.
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
> > 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
pgsql-admin by date
|Next:||From: Darren Reed||Date: 2008-05-02 08:59:29|
|Subject: Re: Bus error in postgres 8.3|
|Previous:||From: Tom Lane||Date: 2008-05-01 20:34:08|
|Subject: Re: COPY errors when trying to convert from 7.4.19 to 8.3.1 |