From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Too easy to log in as the "postgres" user? |
Date: | 2009-10-15 10:55:06 |
Message-ID: | bddc86150910150355u4bc88a8eq2728160641d9a964@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2009/10/15 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2009-10-15 10:58:40 | Re: Too easy to log in as the "postgres" user? |
Previous Message | Glyn Astill | 2009-10-15 10:51:22 | Re: Too easy to log in as the "postgres" user? |