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 F287C9DC81F for ; Sun, 1 Jan 2006 11:30:16 -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 11765-05 for ; Sun, 1 Jan 2006 11:30:21 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8CBB19DC84E for ; Sun, 1 Jan 2006 11:30:14 -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 F265F5AF040 for ; Sun, 1 Jan 2006 15:30:19 +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 F21142702BE for ; Sun, 1 Jan 2006 16:27:39 +0100 (CET) Received: from [192.168.20.46] ([192.168.20.46]) by spheron.com (spheron.com [127.0.0.1]) (MDaemon.PRO.v8.1.2.R) with ESMTP id md50000392134.msg for ; Sun, 01 Jan 2006 16:30:10 +0100 Message-ID: <43B7F57C.5080805@Spheron.com> Date: Sun, 01 Jan 2006 16:30:04 +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 Cc: Peter Childs Subject: Re: Running Postgres on CD - With Win32 References: <43B41B2B.5030303@dennis-wagner.info> In-Reply-To: Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Spam-Processed: spheron.com, Sun, 01 Jan 2006 16:30:10 +0100 (not processed: message from valid local sender) X-MDRemoteIP: 192.168.20.46 X-Return-Path: wagner@Spheron.com X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-MDAV-Processed: spheron.com, Sun, 01 Jan 2006 16:30:12 +0100 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.407 required=5 tests=[AWL=-0.407, HTML_MESSAGE=0.001, INFO_TLD=0.813, MIME_HTML_ONLY=0.001] X-Spam-Score: 0.407 X-Spam-Level: X-Archive-Number: 200601/2 X-Sequence-Number: 20090 Hi Peter!

Of course I don't want to just include a client. For that i would just use Npgsql and that's it. And I wouldn't need a CD/DVD at all. No, I want to export some of the data stored in the (linux-)backend onto the DVD together with a read-only-version of the client-app. And that application is a .NET-(Windows-)app. That would spare me the efford to create two different data-access-methods as I could just change the connection-string and would be through... Perfect solution, iff I can get postgres to run directly from that data-carrying DVD. And I don't want to install postgres on any machine that DVD is run on. Most likely users won't have admin-rights or even priviledged user-rights when they use the created DVD.


...Dennis

Peter Childs schrieb:
If all you want is a client you should just be able to write it and it will connect to the server and work. The client does not need to write just the server.

Peter Childs

On 29/12/05, Dennis Wagner <dennis@dennis-wagner.info> wrote:
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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


-- 
Dennis Wagner

SpheronVR AG                                wagner@spheron.com
Hauptstrasse 186                        http://www.spheron.com

67714 Waldfischbach-Burgalben      Phone +49 63 33 / 27 66 -24
Germany                              Fax +49 63 33 / 27 66 -11