Re: Linux Users vs PostgreSQL Users

Поиск
Список
Период
Сортировка
От Felipe Santos
Тема Re: Linux Users vs PostgreSQL Users
Дата
Msg-id CAPYcRiUvPRcxmVH2FcTHC=M=ZJFQvV03447K_iB6ojTXST6YVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Linux Users vs PostgreSQL Users  (Michael Convey <smconvey@gmail.com>)
Ответы Re: Linux Users vs PostgreSQL Users  (Michael Convey <smconvey@gmail.com>)
Список pgsql-novice
AFAIK there isn´t such a thing.

You are free to create users/roles/groups in Postgres without a match in the Linux system.

They are completely separate things, and you would only end up with the same OS users and DB users if you intended to do so by naming them equally, but still they are different kinds of objects, like cars and fruits.

For convenience and security, the POSTGRES OS user is usually created in the installation process and is related to the POSTGRES DB user by the configuration set in PG_HBA.CONF



2015-11-10 16:41 GMT-02:00 Michael Convey <smconvey@gmail.com>:
​Are PostgreSQL roles always associated with a Linux user account? In other words, can I have a PostgresSQL user account that is unrelated to any Linux account? Is there a detailed tutorial on accounts and roles that explains this topic? I found the following confusing:


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

Предыдущее
От: Michael Convey
Дата:
Сообщение: Linux Users vs PostgreSQL Users
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: Linux Users vs PostgreSQL Users