pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
can ALL database files reside on readonly filesystem
3+ messages / 2 participants
[nested] [flat]

* can ALL database files reside on readonly filesystem
@ 2005-04-09 17:05 Vlad Harchev <hvv@hippo.ru>
  2005-04-09 18:42 ` Re: can ALL database files reside on readonly filesystem Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Vlad Harchev @ 2005-04-09 17:05 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: can ALL database files reside on readonly filesystem
  2005-04-09 17:05 can ALL database files reside on readonly filesystem Vlad Harchev <hvv@hippo.ru>
@ 2005-04-09 18:42 ` Peter Eisentraut <peter_e@gmx.net>
  2005-04-09 19:24   ` Re: can ALL database files reside on readonly filesystem Vlad Harchev <hvv@hippo.ru>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2005-04-09 18:42 UTC (permalink / raw)
  To: Vlad Harchev <hvv@hippo.ru>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: can ALL database files reside on readonly filesystem
  2005-04-09 17:05 can ALL database files reside on readonly filesystem Vlad Harchev <hvv@hippo.ru>
  2005-04-09 18:42 ` Re: can ALL database files reside on readonly filesystem Peter Eisentraut <peter_e@gmx.net>
@ 2005-04-09 19:24   ` Vlad Harchev <hvv@hippo.ru>
  0 siblings, 0 replies; 3+ messages in thread

From: Vlad Harchev @ 2005-04-09 19:24 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-04-09 19:24 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-09 17:05 can ALL database files reside on readonly filesystem Vlad Harchev <hvv@hippo.ru>
2005-04-09 18:42 ` Peter Eisentraut <peter_e@gmx.net>
2005-04-09 19:24   ` Vlad Harchev <hvv@hippo.ru>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox