From: | Jari Aalto <jari(dot)aalto(at)poboxes(dot)com> |
---|---|
To: | pgsql-bugs(at)PostgreSQL(dot)org |
Cc: | jari(dot)aalto(at)poboxes(dot)com |
Subject: | Suggestion: pg_hba.conf - improve postgresql-7.3.2/html/client-authentication.html |
Date: | 2003-05-18 00:40:03 |
Message-ID: | of21krz0.fsf@blue.sea.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
[Keep CC, if you can]
Recently I struggled with access problems with pg_hba.conf.
(see http://cygwin.com/ml/cygwin/2003-05/msg00829.html )
The solution was simple, but to find the error was pure luck.
Would you kindly either
a) add a note to the pg_hba.conf.sample
b) add to the client-authentication.html
Following statement:
"Please, make sure that your authorization file is located in the
*data* directory, not the toplever postgreSQL installation directory.
That is, the file should be located in data/pga_conf"
In my case, there were two pg_hba.conf files, one at
/usr/share/postgresql/ and other at /usr/share/postgresql/data/
After copying the right one into the data/ dir, all worked ok.
This was real puzzle because I stirred the pgra_hba.conf and
changed it multiple times without success. And I never noticed
that it was in wrong directory.
Jari
--
http://tiny-tools.sourceforge.net/
Swatch @time http://www.ryanthiessen.com/swatch/resources.htm
Convert @time http://www.mir.com.my/iTime/itime.htm
From | Date | Subject | |
---|---|---|---|
Next Message | Ruslan A Dautkhanov | 2003-05-20 03:49:14 | Bug in sequence dependency checking |
Previous Message | Jari Aalto | 2003-05-18 00:32:59 | 7.3.2 doc bug - A.1. Getting The Source Via Anonymous CVS |