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