From: Craig May <craig.may@s2.enthdimension.com.au>
To: pgsql-sql@postgresql.org
Subject: Re: pg_hba.conf
Date: Tue, 5 Sep 2000 11:28:04 +0000
Message-ID: <20000905112804.B3016@s2.enthdimension.com.au> (raw)
In-Reply-To: <20000905112733.A3016@s2.enthdimension.com.au>
References: <20000905112733.A3016@s2.enthdimension.com.au>
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 #
> >
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: craig.may@s2.enthdimension.com.au
Subject: Re: pg_hba.conf
In-Reply-To: <20000905112804.B3016@s2.enthdimension.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox