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@xxxxxxxxxxxx] Sent: Wednesday, May 11, 2005 2:51 PM To: Goshen, Galit Cc: pgsql-general@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Storing database in WORM devices <GGoshen@xxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
