On Sat, 2011-07-09 at 11:58 +0000, Greg Sabino Mullane wrote: > > Is it possible to start a postgres cluster or 1 postgres database in > > readonly mode? And - if yes - how can this be done? > > Clusterwide: edit postgresql.conf and set > default_transaction_read_only = on; > > No restart needed, just a reload (HUP) > > Database-wide: > > ALTER DATABASE foobar SET default_transaction_read_only = true; > The only issue is that any user can unset this parameter with a SET query on his session. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
