Re: Suggestion: pg_hba.conf - improve postgresql-7.3.2/html/client-authentication.html - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: Suggestion: pg_hba.conf - improve postgresql-7.3.2/html/client-authentication.html
Date
Msg-id 200305222048.h4MKm7u06264@candle.pha.pa.us
Whole thread Raw
In response to Suggestion: pg_hba.conf - improve postgresql-7.3.2/html/client-authentication.html  (Jari Aalto <jari.aalto@poboxes.com>)
List pgsql-bugs
The file in share is pg_hba.conf.sample, while the one in /data is
pg_hba.conf.  I have not heard of anyone else getting this confused in
the past.

---------------------------------------------------------------------------

Jari Aalto wrote:
>
>     [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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Different results in a loop with RECORD vs ROWTYPE...
Next
From: "Hans Poo"
Date:
Subject: Fix on createdb autocommit no recognized