Re: [ADMIN] Storing database in WORM devices - Mailing list pgsql-general

From Juan Miguel Paredes
Subject Re: [ADMIN] Storing database in WORM devices
Date
Msg-id 9e0a28690505111340324940ef@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Storing database in WORM devices  ("Jay A. Kreibich" <jak@uiuc.edu>)
List pgsql-general
I know it would be a hard approach but... perhaps ON DELETE and ON UPDATE triggers would help?

On 5/11/05, Jay A. Kreibich <jak@uiuc.edu> wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org

pgsql-general by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: [ADMIN] Storing database in WORM devices
Next
From: Robert Treat
Date:
Subject: Re: grant all privileges to all tables in a database