Re: Running Postgres on CD - With Win32

Lists: pgsql-admin
From: Dennis Wagner <dennis(at)dennis-wagner(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Running Postgres on CD - With Win32
Date: 2005-12-29 17:21:47
Message-ID: 43B41B2B.5030303@dennis-wagner.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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

From: Peter Childs <peterachilds(at)gmail(dot)com>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Running Postgres on CD - With Win32
Date: 2005-12-31 14:27:26
Message-ID: a2de01dd0512310627v2eabae2m@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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(at)dennis-wagner(dot)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
>

From: Dennis Wagner <wagner(at)Spheron(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Peter Childs <peterachilds(at)gmail(dot)com>
Subject: Re: Running Postgres on CD - With Win32
Date: 2006-01-01 15:30:04
Message-ID: 43B7F57C.5080805@Spheron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

<!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(at)mail(dot)gmail(dot)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(at)dennis-wagner(dot)info">dennis(at)dennis-wagner(dot)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(at)spheron(dot)com">wagner(at)spheron(dot)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>

Attachment Content-Type Size
unknown_filename text/html 3.5 KB