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@bhi.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
>