Re: creating users per database

Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> Aha ! Indeed, the 7.4 documentation wasn't clear enough on
> that (for me):

> "... The value samegroup specifies that the requested user
> must a member of the group with the same name as the
> requested database. ..."

> Might this be amended to say "... a member of the *database*
> group with ..." ?

The 8.1 documentation uses the term "role", which seems unlikely to be
confused with Unix groups:

: database
:
: Specifies which database names this record matches. The value all
: specifies that it matches all databases. The value sameuser
: specifies that the record matches if the requested database has the
: same name as the requested user. The value samerole specifies that
: the requested user must be a member of the role with the same name
: as the requested database. (samegroup is an obsolete but still
: accepted spelling of samerole.) Otherwise, this is the name of a
: specific PostgreSQL database. Multiple database names can be
: supplied by separating them with commas. A separate file containing
: database names can be specified by preceding the file name with @.

Good enough?

regards, tom lane