On Sat, 2005-01-22 at 15:53 +0100, Josip Rodin wrote:
> 
> The check for "peer" database type in
> /usr/lib/postgresql/bin/postgresql-startup is not strict enough and it
> catches databases that just so happen to be called -- "peer".
> 
> Please fix the regexp match to include a $ at the end so that it only
> matches "peer" in the last element. That is:
> 
> --- /usr/lib/postgresql/bin/postgresql-startup~ Tue Oct 26 22:58:08 2004
> +++ /usr/lib/postgresql/bin/postgresql-startup  Sat Jan 22 15:52:01 2005
> @@ -103,7 +103,7 @@
>         fi
>  fi
>  
> -if grep -qs '^local.*[         ]*peer[         ]' /etc/postgresql/pg_hba.conf
> +if grep -qs '^local.*[         ]*peer[         ]$' 
> /etc/postgresql/pg_hba.conf
>  then
>         echo "Invalid pg_hba.conf authentication spec.  Change all 
> occurrences of
>  peer authentication to ident in /etc/postgresql/pg_hba.conf."

I don't think that would work.  If I remember rightly, "peer" was a
synonym for "ident" to be used for Unix socket connections.
Accordingly, it should be followed by another parameter (as with "ident
sameuser").


Would
  "'^local.*[         ]*peer[         ][^       ]*$'"
do the job?

-- 
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to