chrisstrachan(at)msn(dot)com (chrisstrachan_at_msn.com) writes:
> I can currently log in fine to psql like so,
> #psql template1 -p 5432
> this by default logs you into the local socket but unfortuanately it
> does not work when I try
> #psql template1 -h localhost
> psql: unknown host name: localhost
You have a broken name lookup setup --- either /etc/hosts is wrong,
or you've misconfigured DNS, or quite likely both. It's not
Postgres-specific.
regards, tom lane