pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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> &lt;<a
 href="mailto:dennis@dennis-wagner.info">dennis@dennis-wagner.info</a>&gt;
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>




view thread (3+ messages)

Message-ID: <43B7F57C.5080805@Spheron.com>
Permalink:  ../43B7F57C.5080805@Spheron.com/
Also on:    postgresql.org/message-id/43B7F57C.5080805@Spheron.com

 · 

reply

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