| From: | "Joshua Tolley" <eggyknap(at)gmail(dot)com> |
|---|---|
| To: | "Galland Gregoire" <greg(dot)pg(at)practeo(dot)ch> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Run postgresql engine in readonly mode? |
| Date: | 2008-10-12 01:41:44 |
| Message-ID: | e7e0a2570810111841k4ce9a591w14eb800a25796163@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 9, 2008 at 2:37 AM, Galland Gregoire <greg(dot)pg(at)practeo(dot)ch> wrote:
> Hi all!
>
> I would like to run all my databases in a readonly mode just for a few
> hours (migration plan).
>
> Is it a way to tell the postgresql engine to run in readonly?
>
> Sincerly
>
> G.Galland
>
This comes up periodically on lists. There's not really a way. You can
set transactions as read only (see docs for SET TRANSACTION) but
that's probably not feasible, as you'd have to change your
application. You might create triggers preventing INSERTs and UPDATEs,
but a good bet is just to back up before hand and warn your users.
- Josh / eggyknap
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raj K | 2008-10-12 03:55:39 | Re: Reg: Permission error in Windows psql while trying to read sql commands from file |
| Previous Message | Jeff Soules | 2008-10-12 01:11:02 | Re: Need schema design advice |