Re: [QUESTION] JDBC and pg_hba on 6.2

Forwarded to pgsql-interfaces(at)postgresql(dot)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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org