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 #
> >
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 |