| From: | rob stone <floriparob(at)gmail(dot)com> |
|---|---|
| To: | A Z <poweruserm(at)live(dot)com(dot)au>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Basic Questions about PostgreSQL. |
| Date: | 2021-09-15 08:38:00 |
| Message-ID: | 61c72117499fc76f99542e2c889e8841b6e2db49.camel@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2021-09-15 at 05:10 +0000, A Z wrote:
> -In PostgreSQL, what is the difference between Roles, Groups, and
> Policies exactly? What are they each, how do they relate to one
> another, and which one(s) can be assigned to another?
>
> -Is there a simple, immediate, straightforward way to temporarily
> disable PostgreSQL database
> use of all other users, except development users, or in fact just one
> user (one developer, yourself)
> so that maintenance on the data or the data model may be performed?
>
Read
https://www.postgresql.org/docs/13/app-postgres.html#id-1.9.5.14.6.5
about single user mode.
You shut down the cluster and run psql in single user mode.
After you quit out of single user mode, restart.
HTH,
Rob
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rob stone | 2021-09-15 08:51:09 | Re: SQL queries as sets: was The tragedy of SQL |
| Previous Message | Julien Rouhaud | 2021-09-15 06:45:56 | Re: The tragedy of SQL |