Problem connecting to postgres
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 msAny ideas?
Kind Regards
"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