Today
To: [EMAIL PROTECTED]
cc:
Subject: [SQL] pg_hba.conf
Hi,
i try to connect to my database as $ psql dwnc biosadm but got the error
"psql: FATAL: No pg_hba.conf entry for host localhost, user
biosadm, database dwnc"
Hi,
i try to connect to my database as $ psql dwnc biosadm but got the error
"psql: FATAL: No pg_hba.conf entry for host localhost, user
biosadm, database dwnc"
Below are the detail in pg_hba.conf
# TYPE DATABASEUSERIP-ADDRESSIP-MASK
METHOD
local
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
>
>
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 all0.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 m
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
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.
>
if you are running redhat 6.X as i suspect
you should place that file in /var/lib/pgsql
not /usr/lib/pgsql
ch
On Tue, 05 Sep 2000, Craig May wrote:
> Hi,
>
> I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database
> XXX." I've modified the pg_hba.conf.sample file to allow all access, however
> still getting the same message. Any suggestions?
you have copied pg_hba.conf.sample to pg
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.
On Mon, 04 Sep 2000 07:47:08 Christopher Sawtell wrote:
> On Tue, 05 Sep 2000, Craig May wrote:
> > Hi,
> >
> > I'm recieving an error
Hi,
I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database
XXX." I've modified the pg_hba.conf.sample file to allow all access, however
still getting the same message. Any suggestions?
Regards,
Craig May
