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 4C9E89FA5F0 for ; Wed, 7 Jun 2006 11:24:06 -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 20658-03 for ; Wed, 7 Jun 2006 11:24:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 8257F9FA5D3 for ; Wed, 7 Jun 2006 11:24:01 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 7 Jun 2006 14:23:59 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 07 Jun 2006 09:23:59 -0500 Subject: Re: Standalone Postgres From: Scott Marlowe To: andy.shellam@mailnetwork.co.uk Cc: 'Jarek' , pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1149690239.25526.236.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 07 Jun 2006 09:23:59 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/48 X-Sequence-Number: 22010 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.