| From: | "Sibte Abbas" <sibtay(at)gmail(dot)com> |
|---|---|
| To: | "Panagiotis Pediaditis" <pped(at)ics(dot)forth(dot)gr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Locking entire database |
| Date: | 2007-09-14 14:48:05 |
| Message-ID: | bd6a35510709140748r2eab13b3p3d8ebbc908064a8f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9/14/07, Panagiotis Pediaditis <pped(at)ics(dot)forth(dot)gr> wrote:
> Hello,
>
> Is there some way of locking all database tables in a transaction
> without knowing their names
> or even better just locking the entire database? I know this is bad
> tactics but there is a specific
> case where i need it. Can it be done?
>
AFAIK Locking the entire database may not be an option in postgresql.
However you can virtually restrict access to everyone to a particular
database via pg_hba.conf.
More details here
http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
regards,
--
Sibte Abbas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-09-14 14:50:52 | Re: Locking entire database |
| Previous Message | Panagiotis Pediaditis | 2007-09-14 14:45:07 | Re: Locking entire database |