db security; user identification

Поиск
Список
Период
Сортировка
От Marcin Gil
Тема db security; user identification
Дата
Msg-id 40163DD9.5020204@audax.com.pl
обсуждение исходный текст
Ответы Re: db security; user identification  (Martin Atukunda <matlads@myrealbox.com>)
Re: db security; user identification  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
I have switched identification method from 'trust' to 'md5'
for all local requests, ie:

- local all all 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.

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.

Regards,
--
   Marcin Gil :: marcin.gil@audax.com.pl


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

Предыдущее
От: April Carvalho
Дата:
Сообщение: Another issue with pg_hba.conf file & dumpall
Следующее
От: Marcin Gil
Дата:
Сообщение: unexpected eof