Re: Linux Users vs PostgreSQL Users - Mailing list pgsql-novice

From Felipe Santos
Subject Re: Linux Users vs PostgreSQL Users
Date
Msg-id CAPYcRiUvPRcxmVH2FcTHC=M=ZJFQvV03447K_iB6ojTXST6YVQ@mail.gmail.com
Whole thread Raw
In response to Linux Users vs PostgreSQL Users  (Michael Convey <smconvey@gmail.com>)
Responses Re: Linux Users vs PostgreSQL Users
List 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 by date:

Previous
From: Michael Convey
Date:
Subject: Linux Users vs PostgreSQL Users
Next
From: Alan Hodgson
Date:
Subject: Re: Linux Users vs PostgreSQL Users