rob stone <floriparob@gmail.com> writes:
> On Wed, 2021-09-15 at 05:10 +0000, A Z wrote:
>> -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.
I think a better recommendation is to temporarily modify pg_hba.conf
to disallow logins you don't want. Single-user mode is pretty limited,
because what it really is is single-process mode: there will be no
background support processes such as bgwriter, autovacuum, replication
support, etc. The system runs, more or less, but performance is not
going to be great.
regards, tom lane
