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 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: References: <1317281868.445091@proxy.dienste.wien.at> <1317975042.921423@proxy.dienste.wien.at> 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 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