pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dragan Matic <mlists@panforma.co.yu>
Cc: pgsql-admin@postgresql.org
Subject: Re: read-only database on CD-ROM?
Date: Sat, 26 Mar 2005 13:49:20 -0500
Message-ID: <14173.1111862960@sss.pgh.pa.us> (raw)
In-Reply-To: <42454E96.8070806@panforma.co.yu>
References: <42454E96.8070806@panforma.co.yu>

Dragan Matic <mlists@panforma.co.yu> writes:
> Is it possible to set up a read-only database on external data carrier 
> such as CD-ROM or DVD?

It's not really supported.  I think you could make it work if you did
VACUUM FREEZE in the database, and then CHECKPOINT, just before burning
it on CD.  You can *not* put a whole $PGDATA directory on CD, as the
xlog and clog have to be writable; but you could put one database
subdirectory there.  (It would be a lot easier to use 8.0 and make the
moved-out tree a tablespace, probably.)

A big caveat is that I'm not sure the CD would work if attached to a
different $PGDATA tree, as for instance after a reinstallation.  It
could definitely not be counted on to work across PG version upgrades.
So all in all the answer is probably "not worth the trouble".

			regards, tom lane



view thread (3+ messages)  latest in thread

Message-ID: <14173.1111862960@sss.pgh.pa.us>
Permalink:  ../14173.1111862960@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/14173.1111862960@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, mlists@panforma.co.yu
  Subject: Re: read-only database on CD-ROM?
  In-Reply-To: <14173.1111862960@sss.pgh.pa.us>
  References: <42454E96.8070806@panforma.co.yu> <14173.1111862960@sss.pgh.pa.us>

* 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