rob stone <floriparob@xxxxxxxxx> 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
