Groups > comp.databases.postgresql > #259

Re: Constraints for R/O ./data/{base, et al.}

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: Constraints for R/O ./data/{base, et al.}
Date	Sat, 8 Oct 2011 05:48:36 +0000 (UTC)
Organization	solani.org
Lines	18
Message-ID	<pan.2011.10.08.05.48.36@gmail.com> (permalink)
References	<j5vg74$fbf$1@speranza.aioe.org> <1317281868.445091@proxy.dienste.wien.at> <j6m21t$3bt$1@speranza.aioe.org> <1317975042.921423@proxy.dienste.wien.at> <j6nfdi$mfh$1@speranza.aioe.org>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
X-Trace	solani.org 1318052916 4812 eJwFwYEBwDAEBMCVCP4ZpyT2H6F3YVAMHQGPjf2qmXVRRrrcZy0+Y9F9Ci4sngzbyrtKffMDDtIQjw== (8 Oct 2011 05:48:36 GMT)
X-Complaints-To	abuse@news.solani.org
NNTP-Posting-Date	Sat, 8 Oct 2011 05:48:36 +0000 (UTC)
User-Agent	Pan/0.133 (House of Butterflies)
X-User-ID	eJwFwQERADEIAzBLvy8tIIeD4V/CEkJH7SbKuFyoLyLDth3xX2RpQi4U8zvcLgBTNt02uA8QMBES
Cancel-Lock	sha1:UpNsZWxbO4sMtUbPa2lFvGHawdI=
X-NNTP-Posting-Host	eJwVitsRACEIxFpilZflAEL/JZyXv2QiW6FlrKIsI8Ntdfu+QkxyPaKbp5cOdnnVIEH+bvwQG47lqPsCrG8efYqgzsgh3R/k5RoR
Xref	x330-a1.tempe.blueboxinc.net comp.databases.postgresql:259

Show key headers only | View raw

On Fri, 07 Oct 2011 11:12:04 -0700, Don Y wrote:


>> Is that a theoretical question or do you really plan to move your
>> database to read-only media?
> 
> The latter.  Though I would qualify "database" to be "as much as
> practical", given the issues I put forward in the initial post.

There are databases that do support read only media. MySQL has something 
called myisampack that generates compressed, read only tables. MySQL can 
have read only tables on read only media, like DVD. There are also 
commercial databases that can switch a table or even the entire tablespace 
from read write to read only and back.  Postgresql doesn't have that 
option. You may try using dbi-link to read a read-only table from another 
database and access it from Postgresql.
-- 
http://mgogala.byethost5.com

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Constraints for R/O ./data/{base, et al.} Don Y <nowhere@here.com> - 2011-09-28 08:58 -0700
  Re: Constraints for R/O ./data/{base, et al.} Mladen Gogala <gogala.mladen@gmail.com> - 2011-09-28 18:51 +0000
  Re: Constraints for R/O ./data/{base, et al.} "Laurenz Albe" <invite@spam.to.invalid> - 2011-09-29 09:37 +0200
    Re: Constraints for R/O ./data/{base, et al.} Don Y <nowhere@here.com> - 2011-10-06 22:17 -0700
      Re: Constraints for R/O ./data/{base, et al.} "Laurenz Albe" <invite@spam.to.invalid> - 2011-10-07 10:10 +0200
        Re: Constraints for R/O ./data/{base, et al.} Don Y <nowhere@here.com> - 2011-10-07 11:12 -0700
          Re: Constraints for R/O ./data/{base, et al.} Mladen Gogala <gogala.mladen@gmail.com> - 2011-10-08 05:48 +0000
          Re: Constraints for R/O ./data/{base, et al.} "Laurenz Albe" <invite@spam.to.invalid> - 2011-10-10 16:48 +0200
            Re: Constraints for R/O ./data/{base, et al.} "Laurenz Albe" <invite@spam.to.invalid> - 2011-10-25 12:37 +0200

csiph-web