pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>

view thread (12+ messages)  latest in thread

Message-ID: <9e0a28690505111340324940ef@mail.gmail.com>
Permalink:  ../9e0a28690505111340324940ef@mail.gmail.com/
Also on:    postgresql.org/message-id/9e0a28690505111340324940ef@mail.gmail.com

 · 

reply

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