Re: [HACKERS] read-only database - Mailing list pgsql-patches

From Joshua D. Drake
Subject Re: [HACKERS] read-only database
Date
Msg-id 428028B6.70000@commandprompt.com
Whole thread Raw
In response to Re: [HACKERS] read-only database  (Satoshi Nagayasu <nagayasus@nttdata.co.jp>)
Responses Re: [HACKERS] read-only database
List pgsql-patches
> 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.

pgsql-patches by date:

Previous
From: Satoshi Nagayasu
Date:
Subject: Re: [HACKERS] read-only database
Next
From: Neil Conway
Date:
Subject: pgstat: reduce message header