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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
