can ALL database files reside on readonly filesystem

Поиск
Список
Период
Сортировка
Искать

can ALL database files reside on readonly filesystem

От:
Vlad Harchev <hvv@hippo.ru>
Дата:

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

Re: can ALL database files reside on readonly filesystem

От:
Vlad Harchev <hvv@hippo.ru>
Дата:
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

Re: can ALL database files reside on readonly filesystem

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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/
FAQ