Quick Links

Re: Running Postgres on CD - With Win32

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
Thread:
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! 
 
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:
<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. 
 
Peter Childs 
 
<div>On 29/12/05, Dennis Wagner <<a
href="mailto:dennis(at)dennis-wagner(dot)info">dennis(at)dennis-wagner(dot)info</a>>
wrote:
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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 
</blockquote>
</div>
 
</blockquote>
 
<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

In response to

Re: Running Postgres on CD - With Win32 at 2005-12-31 14:27:26 from Peter Childs

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Szabolcs Andrási	2006-01-01 15:40:48	Connect to PostgreSQL server from an ADSL connection
Previous Message	Magnus Hagander	2006-01-01 12:13:04	Re: Req Documentation for installing PG SQL8.1 by hand