Re: Linux Users vs PostgreSQL Users

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(at)gmail(dot)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:
>
> http://www.postgresql.org/docs/9.3/static/client-authentication.html
> http://www.postgresql.org/docs/9.3/static/user-manag.html
> http://www.postgresql.org/docs/9.3/static/database-roles.html
>