Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Storing database in WORM devices

From: "Jay A(dot) Kreibich" <jak(at)uiuc(dot)edu>
To: GGoshen(at)axsone(dot)com
Cc: armtuk(at)gmail(dot)com, doug(at)mcnaught(dot)org,pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] Storing database in WORM devices
Date: 2005-05-11 20:32:28
Message-ID: 20050511203227.GA8262@uiuc.edu (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On Wed, May 11, 2005 at 03:51:43PM -0400, GGoshen(at)axsone(dot)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(at)uiuc(dot)edu | Campus IT & Edu Svcs
          <http://www.uiuc.edu/~jak> | University of Illinois at U/C

In response to

Responses

pgsql-admin by date

Next:From: Juan Miguel ParedesDate: 2005-05-11 20:40:37
Subject: Re: [GENERAL] Storing database in WORM devices
Previous:From: Richard_D_LevineDate: 2005-05-11 20:31:31
Subject: Re: [GENERAL] Storing database in WORM devices

pgsql-general by date

Next:From: Juan Miguel ParedesDate: 2005-05-11 20:40:37
Subject: Re: [GENERAL] Storing database in WORM devices
Previous:From: Richard_D_LevineDate: 2005-05-11 20:31:31
Subject: Re: [GENERAL] Storing database in WORM devices

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group