Re: Standalone Postgres

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461