Thread: can ALL database files reside on readonly filesystem

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

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

No.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On Sat, Apr 09, 2005 at 08:42:43PM +0200, Peter Eisentraut wrote:
> Vlad Harchev wrote:
> > Is it possible for ALL database files to reside on readonly
> > filesystem (provided all requests made into database are selects)?
>
> No.

OK :(

Thanks for your answer!

--
 Best regards,
  -Vlad