Postgres Pro
Downloads
Home   >   mailing lists

can ALL database files reside on readonly filesystem - Mailing list pgsql-admin

From Vlad Harchev
Subject can ALL database files reside on readonly filesystem
Date
Msg-id 20050409170502.GB3576@h
Whole thread Raw
Responses Re: can ALL database files reside on readonly filesystem
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Vlad Harchev
Date:
Subject: can be database files be copied using 'cp' between hosts with different endianess?
Next
From: Peter Eisentraut
Date:
Subject: Re: can be database files be copied using 'cp' between hosts with different endianess?