Re: Standalone Postgres

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.)

Andy

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of Jarek
> Sent: 07 June 2006 9:11 am
> To: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Standalone Postgres
>
> Dnia 07-06-2006, sro o godzinie 09:01 +0100, Andy Shellam napisal(a):
> > 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.
>
> OK. Let's assume, that I will have self extracting archive, which will
> install all files on some temporary directory on user machine. Will it
> work ?
>
>
> > 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.
>
> I want to create demo of application which uses postgres, so it HAVE to
> be postgres...
>
> best regards
> Jarek
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
> !DSPAM:14,44868a9c256841952411642!
>