X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D417853D73 for ; Wed, 11 May 2005 17:40:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84064-10 for ; Wed, 11 May 2005 20:40:37 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by svr1.postgresql.org (Postfix) with ESMTP id 10C9F53D6D for ; Wed, 11 May 2005 17:40:34 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so344071wra for ; Wed, 11 May 2005 13:40:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=HT8KmB0IvHHIdS+VugfS8bmDiRl+rmNixsOnHtEhmH3W92gqPZkUIQtmED87I4G202jnRmfThAver/ziadJHuAD9Md50tJqN469rN04FBv6pUjt1X9rpSL6T+mJVW6t3P1cQrU39syuKRvaXsD7mA+6xmYj3n2JMIWDmdcbsc8Q= Received: by 10.54.159.16 with SMTP id h16mr492709wre; Wed, 11 May 2005 13:40:37 -0700 (PDT) Received: by 10.54.4.42 with HTTP; Wed, 11 May 2005 13:40:37 -0700 (PDT) Message-ID: <9e0a28690505111340324940ef@mail.gmail.com> Date: Wed, 11 May 2005 16:40:37 -0400 From: Juan Miguel Paredes Reply-To: Juan Miguel Paredes To: jak@uiuc.edu Subject: Re: [GENERAL] Storing database in WORM devices Cc: GGoshen@axsone.com, armtuk@gmail.com, doug@mcnaught.org, pgsql-general@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <20050511203227.GA8262@uiuc.edu> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_866_26014345.1115844037069" References: <20050511203227.GA8262@uiuc.edu> X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200505/130 X-Sequence-Number: 17559 ------=_Part_866_26014345.1115844037069 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I know it would be a hard approach but... perhaps ON DELETE and ON UPDATE= =20 triggers would help? On 5/11/05, Jay A. Kreibich wrote:=20 >=20 > On Wed, May 11, 2005 at 03:51:43PM -0400, GGoshen@axsone.com scratched on= =20 > 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. >=20 > 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. >=20 > -j >=20 > -- > Jay A. Kreibich | CommTech, Emrg Net Tech Svcs > jak@uiuc.edu | Campus IT & Edu Svcs > | University of Illinois at U/C >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? >=20 > http://archives.postgresql.org > ------=_Part_866_26014345.1115844037069 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I know it would be a hard approach but... perhaps ON DELETE and ON UPDATE t= riggers would help?

On 5/11/05, = Jay A. Kreibich <jak@uiuc.edu>= ; wrote:
On Wed, May 11, 2005 at 03:51:43= PM -0400, GGoshen@axsone.com scra= tched 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.<= br>
What you are basically saying is you want a read-only database on a<= br>CD-R (which is essentially a WORM device).  As has been discus= sed
many times in the past, Postgres does not support this very well, if
at = all.

  -j

--
      = ;            &n= bsp; Jay A. Kreibich | CommTech, Emrg Net Tech Svcs
  &nb= sp;            =         jak@uiuc.edu | Campus IT & Edu Svcs
    &nbs= p;    <http://www.ui= uc.edu/~jak> | University of Illinois at U/C

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

   &n= bsp;          http://archives.postgresql.org

------=_Part_866_26014345.1115844037069--