Allan Engelhardt <allane@cybaea.com> writes:
> Peter Eisentraut wrote:
>> This won't work. You need to be able to write to the medium for a number
>> of reasons.
> Is the reason that PostgreSQL must have log files etc. in the same
> directory as the data files
Look again --- they're *not* in the same directory as the data files.
I had interpreted Andrew's question as being about a read-mostly
storage medium, but you're probably right that he wanted it to be
read-only.
I believe it would work to copy individual table files to a read-only
medium after VACUUMing them. You could copy a whole database directory
that way too, but only if you were willing to put up with a completely
read-only database (including no temp tables, for example). It'd
probably make more sense to copy over just the biggest user tables to a
DVD, keeping the system tables on regular read/write media. Right now
this requires hand mucking-about with symlinks for the moved-over
tables, but it's quite doable. We have a TODO item to support
tablespaces, which'd make the bookkeeping a lot easier.
What definitely won't work is to put pg_log or the WAL files on
read-only media ...
regards, tom lane