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 275AF539BB for ; Sat, 26 Mar 2005 21:25:18 +0000 (GMT) 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 45873-07 for ; Sat, 26 Mar 2005 21:25:08 +0000 (GMT) Received: from 3times25.net (duck.3times25.net [66.23.211.34]) by svr1.postgresql.org (Postfix) with ESMTP id 5EFE6539B0 for ; Sat, 26 Mar 2005 21:25:07 +0000 (GMT) Received: from [127.0.0.1] (rhws.home.edu [127.0.0.1]) by 3times25.net (Postfix) with ESMTP id 46C38743F4 for ; Sat, 26 Mar 2005 16:25:07 -0500 (EST) Message-ID: <4245D332.1090104@3times25.net> Date: Sat, 26 Mar 2005 16:25:06 -0500 From: Geoffrey User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050322 Red Hat/1.7.6-1.4.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: read-only database on CD-ROM? References: <42454E96.8070806@panforma.co.yu> <14173.1111862960@sss.pgh.pa.us> In-Reply-To: <14173.1111862960@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/428 X-Sequence-Number: 16926 Tom Lane wrote: > Dragan Matic writes: > >>Is it possible to set up a read-only database on external data carrier >>such as CD-ROM or DVD? > > > It's not really supported. I think you could make it work if you did > VACUUM FREEZE in the database, and then CHECKPOINT, just before burning > it on CD. You can *not* put a whole $PGDATA directory on CD, as the > xlog and clog have to be writable; but you could put one database > subdirectory there. (It would be a lot easier to use 8.0 and make the > moved-out tree a tablespace, probably.) What about making xlog and clog sym links? > > A big caveat is that I'm not sure the CD would work if attached to a > different $PGDATA tree, as for instance after a reinstallation. It > could definitely not be counted on to work across PG version upgrades. > So all in all the answer is probably "not worth the trouble". Oh, come on Tom, sounds like a fun thing to try.... :) -- Until later, Geoffrey