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
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