Обсуждение: Re: [GENERAL] 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
I think simply initialising the system causes writes in the system tables and the WAL... I'm sure someone more knowledgeable can chime in. Alex. Turner netEconomist On 5/11/05, GGoshen@axsone.com <GGoshen@axsone.com> wrote: > 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 > > ---------------------------(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 >
Isn't there some way to trick PostgreSQL with a RAM disk, like for the WAL? Rick pgsql-admin-owner@postgresql.org wrote on 05/11/2005 02:31:55 PM: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly