From: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | Judith Strawser <judiths(at)gtsgraphics(dot)com> |
Subject: | Re: PostGreSQL remote access |
Date: | 2003-06-24 16:59:02 |
Message-ID: | 5.2.1.1.0.20030624095526.00aa4588@mail.gtsgraphics.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Further information:
These are the host lines from our pg_hba.conf file:
host all all 127.0.0.1 255.255.255.255 trust
host all all 0.0.0.0 0.0.0.0
trust
host testdb postgres 208.179.178.94 255.255.255.0 trust
At 03:01 PM 6/23/2003 -0700, you wrote:
>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]
--
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]
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-06-24 17:01:09 | Re: PostGreSQL remote access |
Previous Message | brew | 2003-06-24 05:50:33 | Re: many text files |