pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcan 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