Re: Too easy to log in as the "postgres" user? - Mailing list pgsql-general

From Thom Brown
Subject Re: Too easy to log in as the "postgres" user?
Date
Msg-id bddc86150910150355u4bc88a8eq2728160641d9a964@mail.gmail.com
Whole thread Raw
In response to Re: Too easy to log in as the "postgres" user?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Too easy to log in as the "postgres" user?
List pgsql-general
2009/10/15 A. Kretschmer <andreas.kretschmer@schollglas.com>:
>>
>> The pg_hba.conf is probably relevant here, so this is the setup:
>>
>> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>>
>> # "local" is for Unix domain socket connections only
>> local   all         all                               trust
>> # IPv4 local connections:
>> host    all         all         127.0.0.1/32          trust
>> # IPv6 local connections:
>> host    all         all         ::1/128               trust
>
> Try to change trust to sameuser.
>

I've made that change, but now PostgreSQL won't start, and outputs the
following error in the log:

2009-10-15 11:52:41 BST [18720]: [2-1] CONTEXT:  line 74 of
configuration file "/var/lib/postgresql/8.4/data/pg_hba.conf"
2009-10-15 11:52:41 BST [18720]: [3-1] LOG:  invalid authentication
method "sameuser

pgsql-general by date:

Previous
From: Glyn Astill
Date:
Subject: Re: Too easy to log in as the "postgres" user?
Next
From: Stephen Frost
Date:
Subject: Re: Too easy to log in as the "postgres" user?