From: Dennis Wagner <wagner@Spheron.com>
To: pgsql-admin@postgresql.org
Cc: Peter Childs <peterachilds@gmail.com>
Subject: Re: Running Postgres on CD - With Win32
Date: Sun, 01 Jan 2006 16:30:04 +0100
Message-ID: <43B7F57C.5080805@Spheron.com> (raw)
In-Reply-To: <a2de01dd0512310627v2eabae2m@mail.gmail.com>
References: <43B41B2B.5030303@dennis-wagner.info>
<a2de01dd0512310627v2eabae2m@mail.gmail.com>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Peter!<br>
<br>
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.<br>
<br>
<br>
...Dennis<br>
<br>
Peter Childs schrieb:
<blockquote cite="mida2de01dd0512310627v2eabae2m@mail.gmail.com"
type="cite">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. <br>
<br>
Peter Childs<br>
<br>
<div><span class="gmail_quote">On 29/12/05, <b
class="gmail_sendername">Dennis Wagner</b> <<a
href="mailto:dennis@dennis-wagner.info">dennis@dennis-wagner.info</a>>
wrote:</span>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi
everybody!<br>
<br>
I was using Postgres for quite some time now without any problems. Now<br>
I'm facing some new challenge: Create a Read-Only Client out of a given<br>
Application and put it on CD/DVD. As the Application uses a
<br>
PostgreSQL-DB (running on a FreeBSD-Server) I would like to at least<br>
keep the DB-Interface and use Postgres. The client-app, unfortunatly, is<br>
written for the .NET-Platform and doesn't run under mono (yet). So the
<br>
CD would need to be run under Windows for the moment. I found some<br>
Threads discussion using a Knoppix-like approach to get Postgres running<br>
on a read-only medium but they were all concentrationg on linux. As far
<br>
as I understand there is no way of turning WAL completely off (which<br>
would be ok for a CD-version as false writes cannot occur und thus<br>
cannot destroy the db-content). So then there are two possibilities:<br>
Send all writes to log-files to nirvana (like the good old BOFH used to
<br>
do) or into a memdrive. Has anybody accomplished the task to run<br>
PostgreSQL from CD (even on Linux) and is willing to contribute some of<br>
his/her experiences?<br>
Any help is greatly appreciated.<br>
<br>
<br>
...Dennis
<br>
<br>
<br>
---------------------------(end of broadcast)---------------------------<br>
TIP 5: don't forget to increase your free space map settings<br>
</blockquote>
</div>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Dennis Wagner
SpheronVR AG <a class="moz-txt-link-abbreviated" href="mailto:wagner@spheron.com">wagner@spheron.com</a>
Hauptstrasse 186 <a class="moz-txt-link-freetext" href="http://www.spheron.com">http://www.spheron.com</a;
67714 Waldfischbach-Burgalben Phone +49 63 33 / 27 66 -24
Germany Fax +49 63 33 / 27 66 -11</pre>
</body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: wagner@Spheron.com, peterachilds@gmail.com
Subject: Re: Running Postgres on CD - With Win32
In-Reply-To: <43B7F57C.5080805@Spheron.com>
References: <43B41B2B.5030303@dennis-wagner.info> <a2de01dd0512310627v2eabae2m@mail.gmail.com> <43B7F57C.5080805@Spheron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox