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
