Re: Problem connecting to postgres

"solo" <solo@zoot.dnsalias.net> writes:
> If i use the -h option to specify the hostname it always fails to connect.

> [solo@zoot /root]$ psql -h localhost
> Connection to database 'solo' failed.
> connectDB() --  unknown hostname: localhost

> My localhost is configured properly

> [root@zoot /root]# ping -c 1 localhost
> PING localhost.dnsalias.net (127.0.0.1) from 127.0.0.1 : 56(84) bytes of
> data.
> 64 bytes from localhost (127.0.0.1): icmp_seq=0 ttl=255 time=0.3 ms

Hm.  It would seem that your psql is linked with a broken resolver
library (or at least a different one than ping is using --- it might
be looking at /etc/hosts instead of DNS, or vice versa).

Since you haven't told us anything about your platform or how you
built/obtained psql, it's impossible to say more than that.

            regards, tom lane