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 85E125386F; Wed, 11 May 2005 16:52:20 -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 77036-08; Wed, 11 May 2005 19:52:17 +0000 (GMT) Received: from gatekeeper.axsone.com (unknown [204.142.130.8]) by svr1.postgresql.org (Postfix) with SMTP id 4EBE452951; Wed, 11 May 2005 16:52:15 -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:52:17 -0400 Received: from pubsrv06.axsone.com (unknown [204.142.131.18]) by pubsrv03.axsone.com (Postfix) with ESMTP id 14B3A6EF38; Wed, 11 May 2005 15:56:22 -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:51:04 -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:51:43 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [GENERAL] Storing database in WORM devices Thread-Index: AcVWYWoBGcsZuNGXR062NJrZ4bG6PQAAGE3g From: To: Cc: , , X-OriginalArrivalTime: 11 May 2005 19:51:04.0078 (UTC) FILETIME=[C3BEEAE0:01C55662] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.209 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200505/122 X-Sequence-Number: 17551 I would like to clarify something. I intend to create the database on a re-writable device (not WORM). At = some point, when I no longer want to add/modify the database, I plan to = copy it to the WORM device. Then I would like to be able to access the = database on the WORM device for reading purposes only. I think that the pg_listener catalog is being written for any user = connection. I am not sure whether I could store the system catalogs = separated from the application table spaces. =20 -----Original Message----- From: Alex Turner [mailto:armtuk@gmail.com] Sent: Wednesday, May 11, 2005 3:41 PM To: Goshen, Galit Cc: doug@mcnaught.org; pgsql-general@postgresql.org; pgsql-admin@postgresql.org Subject: Re: [GENERAL] Storing database in WORM devices 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 are 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 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? >=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 = your > joining column's datatypes do not match >