Re: PostGreSQL remote access - Mailing list pgsql-novice

From Mel Jamero
Subject Re: PostGreSQL remote access
Date
Msg-id 004501c33a07$373d9270$1b06a8c0@CMPMEL
Whole thread Raw
In response to PostGreSQL remote access  (David Rickard <David.Rickard@GTScompanies.com>)
List pgsql-novice
You've most probably just misconfigured something in the pg_hba.conf file because of the error message you're getting.  Happened to me more than once.
 
If you allow it, paste the contents of your pg_hba.conf here and surely someone (hopefully one would be me) in the list could point out what's wrong.
 
---
Mel
-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of David Rickard
Sent: Tuesday, June 24, 2003 6:01 AM
To: pgsql-novice@postgresql.org
Cc: Judith Strawser; Dave Cimini
Subject: [NOVICE] 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.Rickard@GTSCompanies.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]

pgsql-novice by date:

Previous
From: "Wilkinson, Graeme"
Date:
Subject: how to update tables and archive the changed data?
Next
From: Josh Berkus
Date:
Subject: Re: how to update tables and archive the changed data?