Skip site navigation (1) Skip section navigation (2)

Re: read-only database on CD-ROM?

From: Geoffrey <esoteric(at)3times25(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: read-only database on CD-ROM?
Date: 2005-03-26 21:25:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Tom Lane wrote:
> Dragan Matic <mlists(at)panforma(dot)co(dot)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

In response to

pgsql-admin by date

Next:From: Joe HalpinDate: 2005-03-26 21:46:27
Subject: Problem setting runpath
Previous:From: Tom LaneDate: 2005-03-26 18:49:20
Subject: Re: read-only database on CD-ROM?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group