X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C12CB9FA5CE for ; Wed, 7 Jun 2006 19:39:39 -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 85959-08 for ; Wed, 7 Jun 2006 19:39:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 214569FA3C0 for ; Wed, 7 Jun 2006 19:39:28 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id B7E3D56480; Wed, 7 Jun 2006 17:39:26 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 7 Jun 2006 17:39:26 -0500 Date: Wed, 7 Jun 2006 17:39:25 -0500 From: "Jim C. Nasby" To: Andy Shellam Cc: 'Jarek' , pgsql-admin@postgresql.org Subject: Re: Standalone Postgres Message-ID: <20060607223925.GD45331@pervasive.com> References: <1149667889.7834.31.camel@jarek.macro.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060607:andy.shellam@mailnetwork.co.uk::Ajd2CIN582lwms6C:0000000 0000000000000000000000000db4 X-Hashcash: 1:20:060607:jarek@poczta.srv.pl::N8fywACCLyWcc/76:000000000000000000 0000000000000000000000005YgV X-Hashcash: 1:20:060607:pgsql-admin@postgresql.org::Fxj5IXFCqo/Cd5UU:00000000000 0000000000000000000000000ZP4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/52 X-Sequence-Number: 22014 On Wed, Jun 07, 2006 at 09:25:18AM +0100, Andy Shellam wrote: > You would need to write your own installation script that would: > a) create the temporary data directory > b) install Postgres with all default options > c) modify the pg_hba.conf file to allow localhost trust access (ie. No > password) - and restart Postgres > d) load the dump of your database into Postgres > e) start your demo and wait for it to exit > f) when demo has exited, stop and uninstall Postgres > g) remove data directory > > It depends how the MSI installer for Postgres will handle the "silent > install" option, but you could use NSIS to do most if not all of this > (http://nsis.sourceforge.net.) And what happens if the user running this is an admin on the box? PostgreSQL will refuse to start. Though, there is a patch floating around that changes that, should you wish to build your own version... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461