Re: db security; user identification

Поиск
Список
Период
Сортировка
От Martin Atukunda
Тема Re: db security; user identification
Дата
Msg-id 200401271450.50206.matlads@myrealbox.com
обсуждение исходный текст
Ответ на db security; user identification  (Marcin Gil <marcin.gil@audax.com.pl>)
Ответы Re: db security; user identification  (Marcin Gil <marcin.gil@audax.com.pl>)
Список pgsql-novice
On Tuesday 27 January 2004 13:30, Marcin Gil wrote:
> I have switched identification method from 'trust' to 'md5'
> for all local requests, ie:
>
> - local all all trust
> + local all all md5

try something like (untested)

- local all all trust
+ local all postgres trust
+ local all all md5

> But that creates a problem:
> - when restarting postgresql it waits for password;
>    how can I work it around?
>
> My target is that pgsql restarts (or starst with system init)
> properly without need of entering password but every connection
> should require it.

the startup script should su to the user postgres and then start the
postmaster.

> If there is no password requirement within local system,
> than every user could do createdb -d dbname -U postgres and
> create a database..
>
> If I am mistaken, please point it out.

- Martin -
--
"If we don't succeed, we run the risk of failure."
--Bill Clinton, President

В списке pgsql-novice по дате отправления:

Предыдущее
От: Patrice Durosay
Дата:
Сообщение: Re: postgre-7.4 and readline-4.3 /solaris 8
Следующее
От: Marcin Gil
Дата:
Сообщение: Re: db security; user identification