From: | "Mel Jamero" <mel(at)gmanmi(dot)tv> |
---|---|
To: | "'David Rickard'" <David(dot)Rickard(at)GTScompanies(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Cc: | "'Judith Strawser'" <judiths(at)gtsgraphics(dot)com>, "'Dave Cimini'" <davec(at)gtsinnova(dot)com> |
Subject: | Re: PostGreSQL remote access |
Date: | 2003-06-24 04:15:15 |
Message-ID: | 004501c33a07$373d9270$1b06a8c0@CMPMEL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of David Rickard
Sent: Tuesday, June 24, 2003 6:01 AM
To: pgsql-novice(at)postgresql(dot)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(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 | Josh Berkus | 2003-06-24 04:28:21 | Re: how to update tables and archive the changed data? |
Previous Message | Wilkinson, Graeme | 2003-06-24 03:42:08 | how to update tables and archive the changed data? |