Re: delivering database stand-alone - Mailing list pgsql-general

From Ang Chin Han
Subject Re: delivering database stand-alone
Date
Msg-id 3F58838B.2030402@bytecraft.com.my
Whole thread Raw
In response to Re: delivering database stand-alone  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian wrote:

> PostgreSQL will not run on read-only medium easily.  If you vacuum full all
> the tables, that will prevent table writes, but we write to pg_clog even
> for select.

You could possibly create a RAM disk, mount it, and initdb, and copy the
entire file needed for writing, and link from the RAM disk to the
read-only medium for the data files.

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
   8:00pm  up 253 days, 11:21,  4 users,  load average: 5.23, 5.16, 5.17

Attachment

pgsql-general by date:

Previous
From: Alex
Date:
Subject: Re: Views with Where Clauses
Next
From: "shreedhar"
Date:
Subject: How can I set postmaster as a service