pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Geoffrey <esoteric@3times25.net>
To: pgsql-admin@postgresql.org
Subject: Re: read-only database on CD-ROM?
Date: Sat, 26 Mar 2005 16:25:06 -0500
Message-ID: <4245D332.1090104@3times25.net> (raw)
In-Reply-To: <14173.1111862960@sss.pgh.pa.us>
References: <42454E96.8070806@panforma.co.yu>
	<14173.1111862960@sss.pgh.pa.us>

Tom Lane wrote:
> 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.)

What about making xlog and clog sym links?
> 
> 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".

Oh, come on Tom, sounds like a fun thing to try.... :)

-- 
Until later, Geoffrey



view thread (3+ messages)

Message-ID: <4245D332.1090104@3times25.net>
Permalink:  ../4245D332.1090104@3times25.net/
Also on:    postgresql.org/message-id/4245D332.1090104@3times25.net

 · 

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: esoteric@3times25.net
  Subject: Re: read-only database on CD-ROM?
  In-Reply-To: <4245D332.1090104@3times25.net>
  References: <42454E96.8070806@panforma.co.yu> <14173.1111862960@sss.pgh.pa.us> <4245D332.1090104@3times25.net>

* 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