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. - Josh / eggyknap -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
