469,156 Members | 2,147 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,156 developers. It's quick & easy.

Disabling PostgreSQL Database General Use for Maintanence Purposes.

10 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?
1 Week Ago #1
0 3408

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
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.