Re: pg_hba.conf - Mailing list pgsql-sql

From Craig May
Subject Re: pg_hba.conf
Date
Msg-id 20000905112804.B3016@s2.enthdimension.com.au
Whole thread Raw
In response to pg_hba.conf  (Craig May <craig.may@s2.enthdimension.com.au>)
List pgsql-sql
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 #
> > 



pgsql-sql by date:

Previous
From: Craig May
Date:
Subject: Re: pg_hba.conf
Next
From: Andreas Tille
Date:
Subject: Re: Order by in stored functions