On Oct 11, 2008, at 6:41 PM, Joshua Tolley wrote:
On Thu, Oct 9, 2008 at 2:37 AM, Galland Gregoire
<greg.pg@xxxxxxxxxx> 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.
set default_transaction_read_only to true?
Not entirely proof against a determined user, but good enough for most
things, I'd guess.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
