X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A3E8D53B9A for ; Sat, 9 Apr 2005 17:39:49 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24985-09 for ; Sat, 9 Apr 2005 16:39:47 +0000 (GMT) Received: from mail.samaralan.ru (unknown [194.186.111.126]) by svr1.postgresql.org (Postfix) with ESMTP id BFC5B53BA9 for ; Sat, 9 Apr 2005 17:39:46 +0100 (BST) Received: by mail.samaralan.ru (Postfix, from userid 106) id 2FEC05C9B; Sat, 9 Apr 2005 20:43:09 +0000 (GMT) Received: from hippo.ru (gw2.tahion.ru [193.27.240.14]) by mail.samaralan.ru (Postfix) with ESMTP id 7A39E5C7C for ; Sat, 9 Apr 2005 20:43:08 +0000 (GMT) Date: Sat, 9 Apr 2005 22:05:02 +0500 From: Vlad Harchev To: pgsql-admin@postgresql.org Subject: can ALL database files reside on readonly filesystem Message-ID: <20050409170502.GB3576@h> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4i X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/108 X-Sequence-Number: 17121 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