X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A8CA0538E0; Wed, 11 May 2005 16:32:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73281-01; Wed, 11 May 2005 19:31:57 +0000 (GMT) Received: from gatekeeper.axsone.com (unknown [204.142.130.8]) by svr1.postgresql.org (Postfix) with SMTP id A17F552951; Wed, 11 May 2005 16:31:55 -0300 (ADT) Received: from pubsrv03.axsone.com by gatekeeper.axsone.com via smtpd (for svr1.postgresql.org [200.46.204.71]) with SMTP; Wed, 11 May 2005 15:31:57 -0400 Received: from pubsrv06.axsone.com (unknown [204.142.131.18]) by pubsrv03.axsone.com (Postfix) with ESMTP id C59596EF1D; Wed, 11 May 2005 15:36:01 -0400 (EDT) Received: from mailsrv1.ctronsoft.com ([192.168.10.71]) by pubsrv06.axsone.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 11 May 2005 15:31:16 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: [GENERAL] Storing database in WORM devices Date: Wed, 11 May 2005 15:31:55 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [GENERAL] Storing database in WORM devices Thread-Index: AcVWXSYEdFIn4ME6QHC9y4Y2HfJlQwAAoNOw From: To: Cc: , X-OriginalArrivalTime: 11 May 2005 19:31:16.0703 (UTC) FILETIME=[0003DEF0:01C55660] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.21 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200505/119 X-Sequence-Number: 17548 Why? Any specific reason that you are aware of ? Are there any writes done to the database when read only SQL statements = are issued? =20 -----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 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. > =20 > Does anyone have such installation, or can determine if this is = possible? AFAIK Postgres will not currently run on a read-only filesystem. -Doug