| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Carlos <Carlos(at)pbsinet(dot)com> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Blocking access to the database?? |
| Date: | 2003-05-29 17:27:48 |
| Message-ID: | 20030529172748.GC15305@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 29, 2003 at 12:29:16 -0400,
Carlos <Carlos(at)pbsinet(dot)com> wrote:
> 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
You could update pg_hba.conf and restart the database server.
Are you sure you want to do that though? You can do consistant backups
while the database is being updated by other people. And people will
see a consistant view of the database if you do your updates properly.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nolan | 2003-05-29 18:18:01 | Re: How to deny user changing his own password? |
| Previous Message | Diogo de Oliveira Biazus | 2003-05-29 17:19:53 | PostgreSQL brazilian community meeting on International Open Source Software Forum |