Re: Data Packaging/Data Unpacking

Поиск
Список
Период
Сортировка
От oleg yusim
Тема Re: Data Packaging/Data Unpacking
Дата
Msg-id CAKd4e_EgT3ZN2CTxSch1g0LutfwKZ60Yo9A1EeGbr44A8yD1aQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Data Packaging/Data Unpacking  (Kevin Grittner <kgrittn@gmail.com>)
Список pgsql-general
Дерево обсуждения
Kevin,

It is understood. But doesn't change things from my perspective. It would anyway be user, with sole access, nobody can elevate privileges to and only root can su to. The name, in that case, is irrelevant, but answer postgres gave me idea of the protection level here.

Thanks,

Oleg

On Wed, Jan 13, 2016 at 4:04 PM, Kevin Grittner <kgrittn@gmail.com> wrote:
On Wed, Jan 13, 2016 at 3:54 PM, oleg yusim <olegyusim@gmail.com> wrote:

> Answer "postgres" would suffice.

But the user would not always be "postgres".  To be accurate, it is
the user which owns the files for the "cluster" (database instance)
and which runs the database service.  If a machine contains
multiple clusters it is (IMO) best practice, for both security and
operational reasons, to use a separate OS user for each cluster.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Data Packaging/Data Unpacking
Следующее
От: "Williamson, Michael"
Дата:
Сообщение: v9.1, DROP TRIGGER IF EXISTS behaving oddly