471,853 Members | 1,805 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

Disabling PostgreSQL Database General Use for Maintanence Purposes.

11 Byte
-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 Maintanence on the data or the data model may be performed?

-The way things are, you after revoke connection priviledges for all the other general users,
cancel all the other connections (except for yourself, or developer user access),
and then perform Maintanence on the database. Thereafter, connection priviledges
have to be restored to all the other users, so that they can choose to connect again.

-Is there a public Extension, for example, that installs and works well, which can be used to do this?
Is there a simple, one hit way to turn a set of user connections all off, and then all on
(regarding their permissions), again?

-All of this strikes me as being very elaborate. Is there a much more simple
way to disable all and subsequent connections to a database, temporarily, and
then allowing them all again, within the PostgreSQL DBMS?
Sep 14 '21 #1
0 6567

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Ish Ahluwalia | last post: by
reply views Thread by David Michael Schruth, | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.