Re: authentication problems

I typed "/usr/local/pgsql/bin/psql -h localhost" and
"/usr/local/pgsql/bin/psql -h 127.0.0.1" and they both returned the
same (odd) message:

psql: FATAL 1: database "postgres" does not exist in the system catalog

I'm connecting through JDBC using 7.1.3 on Darwin (Mac) OS 10.1.

Stefan Huber suggested that I tell JDBC to connect through the
"lo-network" device so that the 127.0.0.1 line in pg_hba.conf works.

thanks for thinking about this problem,

Russ

>Russ McBride <Russ(at)psyex(dot)com> writes:
> > Thanks for the troubleshooting idea Nick. I can ping localhost which
> > does show up as 127.0.0.1. The error message I get is:
> > No entry in pg_hba.conf_file for 169.245.10.10 [or whatever ip
> > address I happen to be using at the time] for user: postgres
> > database: testdb
>
>Hmph. How are you connecting exactly? Do "psql -h localhost" and
>"psql -h 127.0.0.1" produce different results? What do you have in
>/etc/hosts and /etc/resolv.conf?
>
> regards, tom lane