Re: delivering database stand-alone

From: Ang Chin Han <angch(at)bytecraft(dot)com(dot)my>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Joost Kremers <joostkremers(at)fastmail(dot)fm>, pgsql-general(at)postgresql(dot)org
Subject: Re: delivering database stand-alone
Date: 2003-09-05 12:37:31
Message-ID: 3F58838B.2030402@bytecraft.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-09-05 13:01:22 Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!
Previous Message Robert Treat 2003-09-05 12:16:16 Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!