Re: pg_hba.conf broken after cluster upgrade

On 10/16/2013 04:20 PM, Bob Jolliffe wrote:

CCing the list so more eyes can see thid.

> Hi Adrian
>
> Sure.  Here are 6 versions of complete pg_hba.conf files:
>
> 1.  This works (note the auth method is peer not ident.  my first post
> had an error).  Complete one line pg_hba.conf file:
>
> local all postgres peer
>
> 2.  This also works. Another one liner
>
> host all all 127.0.0.1/32 <http://127.0.0.1/32> md5
>
> 3.  This doesn't work
>
> local all postgres peer
> host all all 127.0.0.1/32 <http://127.0.0.1/32> md5
>
> 4.  Neither does this
>
> host all all 127.0.0.1/32 <http://127.0.0.1/32> md5
> local all postgres peer
>
> 5.  This works
>
> host all all 127.0.0.1/32 <http://127.0.0.1/32> md5
> # local all postgres peer
>
> 6.  But this doesn't work
>
> # host all all 127.0.0.1/32 <http://127.0.0.1/32> md5
> local all postgres peer
>
> Failing with the error:
> 2013-10-16 22:46:55 GMT LOG:  configuration file
> "/etc/postgresql/9.2/main/pg_hba.conf" contains no entries
>
> It seems clear to me now looking at 5 and 6 that there seems to be a
> problem parsing the newline which would also be consistent with the
> earlier 4.  I've verified with hexl-mode in emacs that there are no
> funny hidden characters and the lines are terminated by a single 0x0a
> character.
>
> Can't figure out how it can be possible.  The other files eg.
> postgresql.conf are obviously being read fine.


I have never seen this <http://127.0.0.1/32> in a pg_hba,conf. Of course
I don't get out much:) Not sure of its purpose. It seems to be in the
place of the IP mask.

>
> Bob



--
Adrian Klaver
adrian.klaver@gmail.com