Re: STOP all user access except for admin for a few minutes?

From: <org(at)kewlstuff(dot)co(dot)za>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: STOP all user access except for admin for a few minutes?
Date: 2007-01-23 15:15:18
Message-ID: 014101c73f01$4ccf26f0$0a00a8c0@animal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Thx Russel,
I want to control it from software, changing network access via pg_hba with
software doesnt feel right.

================ possible case================
Say I have a Group called Normal_Rights and one called Zero_Rights.

So dB runs as... Normal_Rights(User A, User B, User C, User D)
Then via sql, superuser REVOKEs those user rights and GRANTs them
Zero_Rights(User A, User B, User C, User D)... ie make users a member of the
ZERO rights group.

Then hopefully Postgres kicks them out gracefully?????

Then software make changes and switch's them back to their Normal_Rights
group.

================ or more general case================
RECORD all the SQL for all user rights...
REVOKE everything except needed software superusers (postgres, and program
superuser).
make changes via software.
PLAY BACK all the rights SQL script.

What do you think, will PG kill connections, let them go gracefully, stop
after current transaction????

================ maybe I'm in the wrong tree================
Is it possible to make quick structural changes to postgres, with user
activety?
Maybe start a transaction that changes structure... wonder if that will stop
or hold user activity???

Thx
.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erick Papadakis 2007-01-23 15:15:25 Re: Installing PostgreSQL under Cpanel
Previous Message Alban Hertroys 2007-01-23 15:13:21 Re: Installing PostgreSQL under Cpanel

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2007-01-23 15:19:11 Re: regular expressions stranges
Previous Message Bruce Momjian 2007-01-23 15:11:58 Re: [HACKERS] Win32 WEXITSTATUS too