Re: Blocking access to the database?? - Mailing list pgsql-general

From Network Administrator
Subject Re: Blocking access to the database??
Date
Msg-id 1054227819.3ed63d6b65836@webmail.vcsn.com
Whole thread Raw
In response to Blocking access to the database??  (Carlos <Carlos@pbsinet.com>)
List pgsql-general
Quoting Carlos <Carlos@pbsinet.com>:

> Hi Forum,
>
> Is there a way to block access to the database or terminate ongoing
> connections while I carry-out updates or backups?
>
> Thanks in advance for your reply
>

In the system catalog, the pg_database table has a flag (bool field) that
controls access to the database.  I would think you could set that to false (as
the database admin user) do you work and then set it back to true.

I'm sure there is a better way of doing this though.  So I'm curious what other
people have to suggest.

--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: How to deny user changing his own password?
Next
From: Bruno Wolff III
Date:
Subject: Re: exporting join results