| From: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
|---|---|
| To: | A Z <poweruserm(at)live(dot)com(dot)au> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Basic Questions about PostgreSQL. |
| Date: | 2021-09-15 13:19:49 |
| Message-ID: | CANbhV-FNeE-djw0VdfZUX8fr7FCC9W5Gv+NpLS9doq5xK0rQOg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 15 Sept 2021 at 06:10, A Z <poweruserm(at)live(dot)com(dot)au> 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?
PostgreSQL doesn't require you to eject all other users while such
actions are performed, so we haven't spent a lot of time thinking
about how to deny people access.
What maintenance actions are you thinking are a problem?
--
Simon Riggs http://www.EnterpriseDB.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sridhar Parepalli | 2021-09-15 13:53:55 | How to restore roles into new Database server? |
| Previous Message | Rich Shepard | 2021-09-15 13:01:19 | Re: SQL queries as sets: was The tragedy of SQL |