PostGreSQL remote access

System: sparc-sun-solaris2.6
PostGreSQL build: 7.3.3
Problem: remote access through firewall

We installed PostGreSQL on a Solaris machine; we need to access the db
remotely, via JDBC or through pgAdmin; we have edited the pg_hba.conf file
to (theoretically) allow access to a test db from a developer's PC--but all
access attempts (via JDBC or pgAdmin) are rejected with this error message:

A connection error has occurred: FATAL: No pg_hba.conf entry for
host <IP>, user postgres, database testdb

The IP address returned in the error message is for our firewall;
PostGreSQL is configured to receive tcp/ip requests ( tcpip_socket = true
in the postgresql.conf, and postmaster is started with the -i option); our
sysadmin says that port 5432 is open (as is presumably indicated by the
refused connection attempt);
We can connect to the db via JDBC--when the Java program is run on the same
machine as PostGreSQL;

--

David Rickard
Software Engineer
The GTS Companies
A TechBooks Company

----------------------------------------------------------------------------------

The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA * York, PA * Boston MA * New Delhi, India
----------------------------------------------------------------------------------

David(dot)Rickard(at)GTSCompanies(dot)com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]