Groups > comp.databases.postgresql > #259

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

From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: Constraints for R/O ./data/{base, et al.}
Date	2011-10-08 05:48 +0000
Organization	solani.org
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>

Show all headers | 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