Re: How to start a database in ReadOnly mode? - Mailing list pgsql-admin

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