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 297179DC838 for ; Sat, 31 Dec 2005 10:27:25 -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 96365-09 for ; Sat, 31 Dec 2005 10:27:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by postgresql.org (Postfix) with ESMTP id C85849DC807 for ; Sat, 31 Dec 2005 10:27:22 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i21so1774797wra for ; Sat, 31 Dec 2005 06:27:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:references; b=gOtppYAEtd6d6BuMEfG4bx5w9ssrOmktMOeprU/nMWwBBmCyCIOJCNk4BJ99CXuaGknGSFsBTvrKpCx8GeTrviEI8PDrCVqOlzFsz3r71lJp5qVUWADqtaZtNlb457dkuVQYROcu8oSmLX+XSoGpyzpmfa0Irb1zyT0BJ58of30= Received: by 10.65.216.14 with SMTP id t14mr2960514qbq; Sat, 31 Dec 2005 06:27:26 -0800 (PST) Received: by 10.64.232.7 with HTTP; Sat, 31 Dec 2005 06:27:26 -0800 (PST) Message-ID: Date: Sat, 31 Dec 2005 14:27:26 +0000 From: Peter Childs Subject: Re: Running Postgres on CD - With Win32 Cc: pgsql-admin@postgresql.org In-Reply-To: <43B41B2B.5030303@dennis-wagner.info> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_55586_10361451.1136039246249" References: <43B41B2B.5030303@dennis-wagner.info> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.948 required=5 tests=[HTML_10_20=0.945, HTML_MESSAGE=0.001, INFO_TLD=0.813, MISSING_HEADERS=0.189] X-Spam-Score: 1.948 X-Spam-Level: * X-Archive-Number: 200512/368 X-Sequence-Number: 20088 ------=_Part_55586_10361451.1136039246249 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 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 > ------=_Part_55586_10361451.1136039246249 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 a= ny problems. Now
I'm facing some new challenge: Create a Read-Only Clien= t out of a given
Application and put it on CD/DVD. As the Application us= es a
PostgreSQL-DB (running on a FreeBSD-Server) I would like to at leastkeep the DB-Interface and use Postgres. The client-app, unfortunatly, iswritten 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
T= hreads 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 (whichwould be ok for a CD-version as false writes cannot occur und thus
cann= ot destroy the db-content). So then there are two possibilities:
Send al= l 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
Pos= tgreSQL 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

------=_Part_55586_10361451.1136039246249--