From: Jay A. Kreibich <jak@uiuc.edu>
To: 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 15:32:28 -0500
Message-ID: <20050511203227.GA8262@uiuc.edu> (raw)
In-Reply-To: <E8C21173A4ACCF48BEAB8DA3ABE46F24093807@mailsrv1.ctronsoft.com>
References: <E8C21173A4ACCF48BEAB8DA3ABE46F24093807@mailsrv1.ctronsoft.com>
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
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: 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: <20050511203227.GA8262@uiuc.edu>
References: <E8C21173A4ACCF48BEAB8DA3ABE46F24093807@mailsrv1.ctronsoft.com> <20050511203227.GA8262@uiuc.edu>
* 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