Received: from s2.enthdimension.com.au ([203.36.78.178]) by hub.org (8.10.1/8.10.1) with ESMTP id e850TUC11790 for ; Mon, 4 Sep 2000 20:29:31 -0400 (EDT) Received: (from root@localhost) by s2.enthdimension.com.au (8.9.3/8.8.7) id LAA03035 for pgsql-sql@postgresql.org; Tue, 5 Sep 2000 11:28:04 GMT Date: Tue, 5 Sep 2000 11:28:04 +0000 From: Craig May To: pgsql-sql@postgresql.org Subject: Re: pg_hba.conf Message-ID: <20000905112804.B3016@s2.enthdimension.com.au> Reply-To: craig.may@s2.enthdimension.com.au References: <20000905112733.A3016@s2.enthdimension.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: x-unknown In-Reply-To: <20000905112733.A3016@s2.enthdimension.com.au>; from craig.may@s2.enthdimension.com.au on Tue, Sep 05, 2000 at 11:27:33 +0000 X-Mailer: Balsa 0.8.0 X-Archive-Number: 200009/17 Found it! The file should be located in /var/lib/pgsql/data/ Thanks for your help all =) Craig May Enth Dimension http://www.enthdimension.com.au On Tue, 05 Sep 2000 11:11:25 Craig May wrote: > Ok, > > Here are all the details: > > Redhat 6.1 > pgsql 7.0 > Firewall open on port 3456 > > pg_hba.conf contains the following line > > host all 0.0.0.0 0.0.0.0 trust > > and is now located in both: > > /usr/lib/pgsql/ and /var/lib/pgsql/ > > This file is owned by "postgres". > > The error message is as follows: > > "No pg_pba.conf entry for host 203.36.78.179, usr root, database reflexions" > > I'm using the postgresql jdbc driver. The machines are on the same subnet, > however, there are no additional relations between the machines. The connection > is successful from localhost. Finally, I have restarted the postgresql service > between every change. > > Regards. > Craig May > > Enth Dimension > http://www.enthdimension.com.au > > > On Mon, 04 Sep 2000 10:19:35 Jan Wieck wrote: > > Craig May wrote: > > > > > I've renamed the file to "pg_hba.conf". It's owner and groug are now > postgres. > > > The file is located in /usr/lib/pgsql/. I'm still receiving the same > error. > > > > Network setup? Contents of pg_hba.conf? How should someone > > tell you what's wrong with the information you gave us that > > far? > > > > > > Jan > > > > -- > > > > #======================================================================# > > # It's easier to get forgiveness for being wrong than for being right. # > > # Let's break this rule - forgive me. # > > #================================================== JanWieck@Yahoo.com # > >