Marc G. Fournier wrote:
>On Fri, 9 Jan 2004, Alvaro Herrera wrote
>
>>Does it actually run? I thought Postgres was not prepared to run on
>>read-only media. It needs a separate PGDATA area, doesn't it?
>>
>>
>
>In theory, you *should* be able to build memory file systems for those
>parts that require r/w ... ie. xlog stuff ... but even then, if you don't
>do any update/insert/deletes, and just use the database read only, not
>sure how "required" that is ... but, all you'd need to do is:
>
>mount_mfs a memory file system
>cp the xlog directory to the memory file system
>mount_union (or equivalent) back to the xlog directory
>
>
The distribution that will come with the No Starch Press book will
allow for full-blown read/write abilities and can be adopted to work
with a database cluster of 'any' size.