Re: postgres database user account

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postgres database user account
Дата
Msg-id 16427.1277929003@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: postgres database user account  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Список pgsql-admin
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> writes:
> so what about the operating system account that is different?  What we
> are planning on doing with the OS acct (postgres) is only allowing users
> sudo ability to this account.  Nobody should be able to directly log
> into it.  Do you think that will cause problems?

No, that's pretty standard.  RPM installations for example have never
assigned a password to the postgres OS account, so it will behave in
exactly that way.

Usually the only things you need the OS account for are to start/stop
the server and update its outside-the-database configuration files,
such as postgresql.conf.

            regards, tom lane

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