pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
read-only database on CD-ROM?
3+ messages / 3 participants
[nested] [flat]

* read-only database on CD-ROM?
@ 2005-03-26 11:59  Dragan Matic <mlists@panforma.co.yu>
  0 siblings, 1 reply; 3+ messages in thread

From: Dragan Matic @ 2005-03-26 11:59 UTC (permalink / raw)
  To: pgsql-admin

Is it possible to set up a read-only database on external data carrier 
such as CD-ROM or DVD? I couldn't find anything similar in postgres 
documentation. I have an old database  which I would like to put on to 
CD-ROM and to be able to read it occasionaly. I appreciate any hint if 
that would be possible or link to documentation.
Thanks in advance

Dragan Matic




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: read-only database on CD-ROM?
@ 2005-03-26 18:49  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Dragan Matic <mlists@panforma.co.yu>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2005-03-26 18:49 UTC (permalink / raw)
  To: Dragan Matic <mlists@panforma.co.yu>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: read-only database on CD-ROM?
@ 2005-03-26 21:25  Geoffrey <esoteric@3times25.net>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Geoffrey @ 2005-03-26 21:25 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-03-26 21:25 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-26 11:59 read-only database on CD-ROM? Dragan Matic <mlists@panforma.co.yu>
2005-03-26 18:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-03-26 21:25   ` Geoffrey <esoteric@3times25.net>

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