Re: Storing database in WORM devices

Why? Any specific reason that you are aware of ?
Are there any writes done to the database when read only SQL statements are issued?


-----Original Message-----
From: Douglas McNaught [mailto:doug@mcnaught.org]
Sent: Wednesday, May 11, 2005 2:51 PM
To: Goshen, Galit
Cc: pgsql-general@postgresql.org; pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Storing database in WORM devices


<GGoshen@axsone.com> writes:

> I would like to store the complete database into a WORM device (Write Once
> Read Many). I would like to access this database directly from the WORM
> device and perform read only SQL statements against this device.
>
> Does anyone have such installation, or can determine if this is possible?

AFAIK Postgres will not currently run on a read-only filesystem.

-Doug