Re: Error connecting when user has no password

On Sat, 16 Oct 2004, Ed Tyrrill wrote:

> I am in the process of moving our application from postgresql 7.2.1-5 to
> 7.3.6-7.  I also changed the jdbc driver we use from pg72jdbc2.jar to
> pg73jdbc2.jar.  I can no longer get a connection for users that have
> no password from java.  I couldn't figure out why I couldn't get a
> connection with our usual user that has no database password, and then
> on a hunch tried using a different user that has a password, and
> everything worked fine.  The no password user can connect using psql
> with no problems.
>

This looks like a difference in your setup of pg_hba.conf.  Using psql is
not a valid test unless you use the "-h localhost" option to force it to
connect over tcpip sockets instead of unix sockets because these have
different lines in pg_hba.conf.

Kris Jurka