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 A15515322E for ; Wed, 11 May 2005 16:41:25 -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 74649-05 for ; Wed, 11 May 2005 19:41:20 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by svr1.postgresql.org (Postfix) with ESMTP id EF1BF53228 for ; Wed, 11 May 2005 16:41:19 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so426684wri for ; Wed, 11 May 2005 12:41:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=emBUwHRnJd95t5QVKfffG4IwSgNquR9O8dKy7HFFk+QrtlpKIEp7KlQhKio0Ka5ZLfn0HL5i64J2V7AEh0vKT9gCCKj4bmfb0m3PsgkiYIjf7ljeayqA6OZHKItW6cgs4mdKKqchKF7Oguu+tN59caCayC7vduEEFcnrPW8eCjs= Received: by 10.54.41.77 with SMTP id o77mr623289wro; Wed, 11 May 2005 12:41:21 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Wed, 11 May 2005 12:41:21 -0700 (PDT) Message-ID: <33c6269f05051112412482456@mail.gmail.com> Date: Wed, 11 May 2005 15:41:21 -0400 From: Alex Turner Reply-To: Alex Turner To: "GGoshen@axsone.com" Subject: Re: [GENERAL] Storing database in WORM devices Cc: doug@mcnaught.org, pgsql-general@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.512 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200505/120 X-Sequence-Number: 17549 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 wrote: > Why? Any specific reason that you are aware of ? > Are there any writes done to the database when read only SQL statements a= re issued? >=20 >=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 >=20 > writes: >=20 > > I would like to store the complete database into a WORM device (Write O= nce > > 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 possibl= e? >=20 > AFAIK Postgres will not currently run on a read-only filesystem. >=20 > -Doug >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if you= r > joining column's datatypes do not match >