X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 26DC59FA3AD for ; Wed, 7 Jun 2006 15:41:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 58851-07 for ; Wed, 7 Jun 2006 15:41:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id BDF289FA2E6 for ; Wed, 7 Jun 2006 15:41:16 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id q2so455998uge for ; Wed, 07 Jun 2006 11:41:15 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=LeTyXmtr8FUYNH7IXKTfVJWRtZos5pJ4ydYE674I4iAPoPFEXs5rfd/8rnowWqp3AhS1f7smGTZPn68/5QVp5lpWq9AXLHVs7IGfGFVUdOUtPo4dQjGty0YbhW36vW2n8kA1CZfdCyRtGlrEzMrPc03aEmB1Zqsr4ABPJrAA7cc= Received: by 10.67.25.9 with SMTP id c9mr804470ugj; Wed, 07 Jun 2006 11:41:15 -0700 (PDT) Received: by 10.67.20.12 with HTTP; Wed, 7 Jun 2006 11:41:14 -0700 (PDT) Message-ID: Date: Wed, 7 Jun 2006 13:41:14 -0500 From: "Aaron Bono" To: pgsql-admin@postgresql.org Subject: Re: Standalone Postgres In-Reply-To: <1149690239.25526.236.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9359_25704775.1149705674961" References: <1149690239.25526.236.camel@state.g2switchworks.com> X-Google-Sender-Auth: 72f083eee17e4611 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/51 X-Sequence-Number: 22013 ------=_Part_9359_25704775.1149705674961 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline You might check out Knoppix. If your app will run on Linux you could create a full bootable Knoppix CD with everything installed - then they can play around all they want and just reboot to reset everything. I am not sure if there is a Knoppix distro that can run within Windows. I do video demos. I know that doesn't allow the user to play but you can really show off the tool in a controlled manner. Check Instant Demo at http://www.instant-demo.com/ - I bought it recently and love it. It even makes Flash versions so you can put them up on your web site. -Aaron On 6/7/06, Scott Marlowe wrote: > > On Wed, 2006-06-07 at 03:01, Andy Shellam wrote: > > > > > Hello! > > > > > > Is it possible to have a CD with database and postgres binaries > > > (win32), which can be directly run (without any installation) ? Or if > it > > > is impossible to be run from read-only media, to have it as > > > self-extracting archive, which can be run from any user account ? > > > The goal is to have some demonstration CD with some viewer, database > and > > > postgres engine, which can be easily run by any windows user without > > > installation. > > > > > > best regards > > > Jarek > > > > > You won't be able to run it all off CD no, as Postgres requires > > log/transaction files etc to be written to. It also requires a service > > user/data directory so it would have to be installed. > > > > If you don't require the functionality etc of Postgres (and haven't > > developed your solution yet) you might be better off looking at > something > > like SQLlite, which uses flat-files. > > Actually there is a live pg cd distro out there somewhere. I've got a > copy of it I can reseed the torrent if anyone wants it. > > I'm sure it's a bit out of date by now, but it's a pretty cool little > trick. ------=_Part_9359_25704775.1149705674961 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline You might check out Knoppix.  If your app will run on Linux you could create a full bootable Knoppix CD with everything installed - then they can play around all they want and just reboot to reset everything.  I am not sure if there is a Knoppix distro that can run within Windows.

I do video demos.  I know that doesn't allow the user to play but you can really show off the tool in a controlled manner.  Check Instant Demo at http://www.instant-demo.com/ - I bought it recently and love it.  It even makes Flash versions so you can put them up on your web site.

-Aaron

On 6/7/06, Scott Marlowe < smarlowe@g2switchworks.com> wrote:
On Wed, 2006-06-07 at 03:01, Andy Shellam wrote:


> > Hello!
> >
> >     Is it possible to have a CD with database and postgres binaries
> > (win32), which can be directly run (without any installation) ? Or if it
> > is impossible to be run from read-only media, to have it as
> > self-extracting archive, which can be run from any user account ?
> > The goal is to have some demonstration CD with some viewer, database and
> > postgres engine, which can be easily run by any windows user without
> > installation.
> >
> > best regards
> > Jarek
> >
> You won't be able to run it all off CD no, as Postgres requires
> log/transaction files etc to be written to.  It also requires a service
> user/data directory so it would have to be installed.
>
> If you don't require the functionality etc of Postgres (and haven't
> developed your solution yet) you might be better off looking at something
> like SQLlite, which uses flat-files.

Actually there is a live pg cd distro out there somewhere.  I've got a
copy of it I can reseed the torrent if anyone wants it.

I'm sure it's a bit out of date by now, but it's a pretty cool little
trick.
------=_Part_9359_25704775.1149705674961--