Re: pg_hba.conf

From: Craig May <craig(dot)may(at)s2(dot)enthdimension(dot)com(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_hba.conf
Date: 2000-09-05 11:28:04
Message-ID: 20000905112804.B3016@s2.enthdimension.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Yahoo(dot)com #
> >

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2000-09-05 17:53:22 Re: Re: Order by in stored functions
Previous Message Craig May 2000-09-05 11:11:25 Re: pg_hba.conf