FWD: [QUESTION] JDBC and pg_hba on 6.2

Hello PG interface gurus,

Sorry for the redundant message... Scrappy forwarded this to your list
but I am not active on this list. Could you please CC me (basham(at)bhi(dot)com)
with answers.

-Bryan Basham

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
>