Am Sat, Oct 29, 2022 at 08:20:50PM -0700 schrieb Bryn Llewellyn:

> For the purpose of the tests that follow, I set up the O/S users "bob" and 
> "mary" so that "id bob mary postgres" shows this:
>
> id=1002(bob)       gid=1001(postgres) groups=1001(postgres)
> uid=1003(mary)     gid=1001(postgres) groups=1001(postgres)
> uid=1001(postgres) gid=1001(postgres) 
> groups=1001(postgres),27(sudo),114(ssl-cert)
>
> And I set up the cluster-roles "bob" and "mary" so that "\du" shows this:
>
> bob       |                                                            | {}
> mary      |                                                            | {}
> postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

Just a hint: you may want to use "mary_os" and "mary_db",
respectively, such that error messages can become less
ambivalent... (same for bob*).

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B


Reply via email to