pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedread-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>
2005-03-26 18:49 ` Re: read-only database on CD-ROM? Tom Lane <tgl@sss.pgh.pa.us>
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 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 ` Re: read-only database on CD-ROM? Geoffrey <esoteric@3times25.net>
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 11:59 read-only database on CD-ROM? Dragan Matic <mlists@panforma.co.yu>
2005-03-26 18:49 ` Re: read-only database on CD-ROM? Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-03-26 21:25 ` Geoffrey <esoteric@3times25.net>
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