Re: [QUESTION] JDBC and pg_hba on 6.2

Forwarded to pgsql-interfaces@postgresql.org


On Mon, 9 Mar 1998, Bryan Basham wrote:

> Hello,
>
> I have been using PostgreSQL 6.2 and JDBC for a few months now, but
> only accessing the DB from my local host.  I am now attempting to
> connect to my DB server host remotely (the remote server is gru.org
> and my local host is bela.basham.bhi.com).
>
> I tried the JDBC_Test program, but it fails:
>
> > java JDBC_Test jdbc:postgresql://gru.org:5432/gru
> Connecting to Database URL = jdbc:postgresql://gru.org:5432/gru
> Exception: java.sql.SQLException: Failed to authenticate client as Postgres
>   user 'basham' using the default authentication type: be_recvauth: host-based authentication failed
>
> I have the following entry in the servers pg_hba.conf file:
>
> # All any connection from Bela.Basham.BHI.COM
> host         all         10.237.124.1  255.255.255.255   trust
>
> I restarted the postmaster after changing the pg_hba.conf file
> and it still fails (message above).  Any ideas?
>
> Thanks,
> Bryan Basham
>

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org