On E, 2005-05-09 at 20:21 -0700, Joshua D. Drake wrote:
> > As I mentioned before, I wanted to the read-only database mode.
> > It is the per-database state.
> >
> > http://archives.postgresql.org/pgsql-hackers/2005-03/msg00540.php
> >
> > However, if it is not provided, we have to find alternative way
> > to get our purpose.
> >
> > So I'm still looking for how to make the (user) database as read-only.
> >
>
> Mammoth PostgreSQL Replicator could do this. If you set a database to a
> slave and tell it to be a slave for all tables it would be read only.
Would it still not have the same issues as Slony (one can create new
tables) this patch (one can create temp tables) ?
--
Hannu Krosing <hannu@tm.ee>