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 по дате отправления:

Предыдущее
От: "Maria L. Wilson"
Дата:
Сообщение: Re: postgres database user account
Следующее
От: Tom Lane
Дата:
Сообщение: Re: cache lookup failed for index