From: Bryan Basham <basham@bhi.com>
Date: Tue, 10 Mar 1998 09:55:18 -0700 (MST)
Message-Id: <199803101655.JAA11848@sabrina.secure.bhi.com>
To: pgsql-interfaces@postgresql.org
Subject: FWD: [QUESTION] JDBC and pg_hba on 6.2
Cc: basham@bhi.com

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
>