Re: [HACKERS] read-only database

Joshua D. Drake <jd@commandprompt.com>

From: "Joshua D. Drake" <jd@commandprompt.com>

To: Satoshi Nagayasu <nagayasus@nttdata.co.jp>

Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@dcc.uchile.cl>, pgsql-patches@postgresql.org

Date: 2005-05-10T03:21:26Z

Lists: pgsql-hackers

> 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.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.