Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Storing database in WORM devices - Mailing list pgsql-admin

From Jay A. Kreibich
Subject Re: [GENERAL] Storing database in WORM devices
Date
Msg-id 20050511203227.GA8262@uiuc.edu
Whole thread Raw
In response to Re: [GENERAL] Storing database in WORM devices  (<GGoshen@axsone.com>)
Responses Re: [GENERAL] Storing database in WORM devices
List pgsql-admin
Tree view 
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
          <http://www.uiuc.edu/~jak> | University of Illinois at U/C

pgsql-admin by date:

Previous
From: "Ing. Jhon Carrillo"
Date:
Subject: pgadmin
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: [GENERAL] Storing database in WORM devices