X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DFC929DC833 for ; Thu, 29 Dec 2005 13:21:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62251-05 for ; Thu, 29 Dec 2005 13:21:56 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D8D899DCA05 for ; Thu, 29 Dec 2005 13:21:55 -0400 (AST) Received: from 115.N1.EF.nwx-server.de (115.N1.EF.nwx-server.de [217.114.219.115]) by svr4.postgresql.org (Postfix) with ESMTP id D0BCF5AFAF7 for ; Thu, 29 Dec 2005 17:21:55 +0000 (GMT) Received: from spheron.com (Eaa03.ex.pppool.de [194.97.170.3]) by 115.N1.EF.nwx-server.de (Postfix) with ESMTP id 67A9B2702BA for ; Thu, 29 Dec 2005 18:19:33 +0100 (CET) Received: from [192.168.0.21] ([192.168.0.21]) by spheron.com (spheron.com [127.0.0.1]) (MDaemon.PRO.v8.1.2.R) with ESMTP id md50000391212.msg for ; Thu, 29 Dec 2005 18:21:47 +0100 Message-ID: <43B41B2B.5030303@dennis-wagner.info> Date: Thu, 29 Dec 2005 18:21:47 +0100 From: Dennis Wagner Organization: SpheronVR AG User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Running Postgres on CD - With Win32 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Processed: spheron.com, Thu, 29 Dec 2005 18:21:47 +0100 (not processed: message from trusted or authenticated source) X-MDRemoteIP: 192.168.0.21 X-Return-Path: dennis@dennis-wagner.info X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-MDAV-Processed: spheron.com, Thu, 29 Dec 2005 18:21:48 +0100 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/367 X-Sequence-Number: 20087 Hi everybody! I was using Postgres for quite some time now without any problems. Now I'm facing some new challenge: Create a Read-Only Client out of a given Application and put it on CD/DVD. As the Application uses a PostgreSQL-DB (running on a FreeBSD-Server) I would like to at least keep the DB-Interface and use Postgres. The client-app, unfortunatly, is written for the .NET-Platform and doesn't run under mono (yet). So the CD would need to be run under Windows for the moment. I found some Threads discussion using a Knoppix-like approach to get Postgres running on a read-only medium but they were all concentrationg on linux. As far as I understand there is no way of turning WAL completely off (which would be ok for a CD-version as false writes cannot occur und thus cannot destroy the db-content). So then there are two possibilities: Send all writes to log-files to nirvana (like the good old BOFH used to do) or into a memdrive. Has anybody accomplished the task to run PostgreSQL from CD (even on Linux) and is willing to contribute some of his/her experiences? Any help is greatly appreciated. ...Dennis