Re: [HACKERS] read-only database
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Satoshi Nagayasu <nagayasus@nttdata.co.jp>, pgsql-patches@postgresql.org
Date: 2005-05-06T23:35:31Z
Lists: pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes: > It seems server_read_only is the same as default_transaction_read_only > except it can't be changed. I thought the TODO item was for a low-level read-only option, suitable for trying to look at a corrupted database or run off a read-only volume. This is very far from being that --- it allows temp table creation/use, and it still eats transaction IDs so it is certainly not read-only to xlog or clog. I am not sure I see any use case for this implementation: it is read-only enough to get in your way, without being read-only enough to derive any real benefit. regards, tom lane