Re: Standalone Postgres - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: Standalone Postgres
Date
Msg-id 20060607223925.GD45331@pervasive.com
Whole thread Raw
In response to Re: Standalone Postgres  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: Standalone Postgres
Next
From: "Jim C. Nasby"
Date:
Subject: Re: growth of a postgresql database