Re: Problem with createdb

Hi Tom,
You are right. If I try to ping 127.0.0.1, it gives destination unreachable. Something seriously wrong with network configuration.

*********
# ping 127.0.0.1
ICMP Host Unreachable from gateway XXXX (y.y.y.y)
for icmp from XXXX (y.y.y.y) to localhost (127.0.0.1)
ICMP Host Unreachable from gateway XXXX (y.y.y.y)
for icmp from XXXX (y.y.y.y) to localhost (127.0.0.1)

[XXXX - Host name,
y.y.y.y - Actual address of the interface of this machine]
*********

I am running Solaris 10 on SPARC.

Regards,
DP

----- Original Message ----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Durgaprasad Pawar <durgaprasad(dot)pawar(at)yahoo(dot)co(dot)in>
Cc: pgsql-novice(at)postgresql(dot)org
Sent: Tuesday, 30 October, 2007 8:52:35 PM
Subject: Re: [NOVICE] Problem with createdb

Durgaprasad Pawar <durgaprasad(dot)pawar(at)yahoo(dot)co(dot)in> writes:
> bin # ./createdb -U dpgres -p 9999 -h 127.0.0.1 -q mydb
> createdb: could not connect to database postgres: could not
> connect to server: No route to host

"No route to host" for 127.0.0.1 ???

There's something seriously hosed about your networking configuration.
This isn't a Postgres-specific problem --- no doubt you'll find that
any
TCP-based connection fails similarly, eg telnet. Since you didn't
mention what platform this is, there's not much help we can give, but
in any case you should find an OS-specific help list for it.

regards, tom lane

Forgot the famous last words? Access your message archive online at http://in.messenger.yahoo.com/webmessengerpromo.php