Thread: Problem connecting to postgres

Problem connecting to postgres

From
"solo"
Date:
Hi,

I'm having a problem when i try to connect to the database.
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

--- localhost.dnsalias.net ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max = 0.3/0.3/0.3 ms

Any ideas?

Kind Regards


Re: Problem connecting to postgres

From
Tom Lane
Date:
"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