can ALL database files reside on readonly filesystem

From: Vlad Harchev <hvv(at)hippo(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: can ALL database files reside on readonly filesystem
Date: 2005-04-09 17:05:02
Message-ID: 20050409170502.GB3576@h
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello,

Is it possible for ALL database files to reside on readonly filesystem
(provided all requests made into database are selects)?

I guess psql will have to create temporary tables for sorting and joining,
will it automatically detect that all tables reside on readonly device and
will place temporary files in some other directory like $TEMP ?

Thanks in advance for your answers!!
--
Best regards,
-Vlad

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2005-04-09 18:42:19 Re: can be database files be copied using 'cp' between hosts with different endianess?
Previous Message Vlad Harchev 2005-04-09 17:03:06 can be database files be copied using 'cp' between hosts with different endianess?