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 182EF53CED; Wed, 11 May 2005 17:32:44 -0300 (ADT) 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 84127-03; Wed, 11 May 2005 20:32:41 +0000 (GMT) Received: from expredir5.cites.uiuc.edu (expredir5.cites.uiuc.edu [128.174.5.96]) by svr1.postgresql.org (Postfix) with ESMTP id 1286253CD6; Wed, 11 May 2005 17:32:38 -0300 (ADT) Received: from firefox.cites.uiuc.edu (tantris.near.uiuc.edu [128.174.250.228]) by expredir5.cites.uiuc.edu (8.12.11/8.12.11) with ESMTP id j4BKWSk5023234; Wed, 11 May 2005 15:32:33 -0500 (CDT) Received: by firefox.cites.uiuc.edu (Postfix, from userid 79964) id 54D4C3A231F; Wed, 11 May 2005 15:32:28 -0500 (CDT) Date: Wed, 11 May 2005 15:32:28 -0500 From: "Jay A. Kreibich" To: GGoshen@axsone.com Cc: armtuk@gmail.com, doug@mcnaught.org, pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] Storing database in WORM devices Message-ID: <20050511203227.GA8262@uiuc.edu> Reply-To: jak@uiuc.edu References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-URL: http://www.uiuc.edu/~jak (includes PGP key) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/128 X-Sequence-Number: 17557 On Wed, May 11, 2005 at 03:51:43PM -0400, GGoshen@axsone.com scratched on the wall: > I would like to clarify something. > I intend to create the database on a re-writable device (not WORM). > At some point, when I no longer want to add/modify the database, I > plan to copy it to the WORM device. Then I would like to be able to > access the database on the WORM device for reading purposes only. What you are basically saying is you want a read-only database on a CD-R (which is essentially a WORM device). As has been discussed many times in the past, Postgres does not support this very well, if at all. -j -- Jay A. Kreibich | CommTech, Emrg Net Tech Svcs jak@uiuc.edu | Campus IT & Edu Svcs | University of Illinois at U/C