From: Juan Miguel Paredes <juan.paredes@gmail.com>
To: jak@uiuc.edu
Cc: GGoshen@axsone.com
Cc: armtuk@gmail.com
Cc: doug@mcnaught.org
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Storing database in WORM devices
Date: Wed, 11 May 2005 16:40:37 -0400
Message-ID: <9e0a28690505111340324940ef@mail.gmail.com> (raw)
In-Reply-To: <20050511203227.GA8262@uiuc.edu>
References: <E8C21173A4ACCF48BEAB8DA3ABE46F24093807@mailsrv1.ctronsoft.com>
<20050511203227.GA8262@uiuc.edu>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: juan.paredes@gmail.com, jak@uiuc.edu, GGoshen@axsone.com, armtuk@gmail.com, doug@mcnaught.org, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Storing database in WORM devices
In-Reply-To: <9e0a28690505111340324940ef@mail.gmail.com>
References: <E8C21173A4ACCF48BEAB8DA3ABE46F24093807@mailsrv1.ctronsoft.com> <20050511203227.GA8262@uiuc.edu> <9e0a28690505111340324940ef@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox