Re: Too easy to log in as the "postgres" user?
| От | Thom Brown |
|---|---|
| Тема | Re: Too easy to log in as the "postgres" user? |
| Дата | |
| Msg-id | bddc86150910150355u4bc88a8eq2728160641d9a964@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Too easy to log in as the "postgres" user? ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
| Ответы |
Re: Too easy to log in as the "postgres" user?
|
| Список | 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 по дате отправления: