From: Darcy Buskermolen <darcyb@commandprompt.com>
Organization: CommandPrompt Inc.
To: pgsql-admin@postgresql.org
Subject: Re: running PostGres without installing it
Date: Tue, 8 Aug 2006 14:00:55 -0700
User-Agent: KMail/1.8.3
Cc: jesus martinez <jesus_martinez1967@yahoo.com.ar>
References: <20060806040747.99775.qmail@web32509.mail.mud.yahoo.com>
In-Reply-To: <20060806040747.99775.qmail@web32509.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200608081400.55954.darcyb@commandprompt.com>

On Saturday 05 August 2006 21:07, jesus martinez wrote:
> hello, how are you ?
>
> i want to distribute a copy of PostGres to my clients.
> they really dont know anything about installing
> programs or
> configurating remote RDBMS sql-servers,
> so i dont want to give them the
> "official-PostGres-installer.exe"
> but my own installer.exe (win32) that:
>
> 1) install the PostGres's required files
> 2) modify the system as PostGres needs (registry,
> paths, etc)
> 3) execute it as a process, not as a service (if it is
> possible)
> (it must run also on win98 machines)

PostgreSQLl needs an NT like system to run on, so 98 is not an option.

> 4) enable the server in a port readed from an INI file
> or
> something like that.
> 5) delete the default super-user or change its
> password
> 6) creates the tables-structure that my client-app
> needs
> 7a) insert the data or
> 7b) copy db-files to hdd, assign them in PostGres and
> make
> them available via PostGres.
> 8) create the dbuser that will be used by clients-apps
> 9) assign that dbuser to my tables
>
> all without any kind of user interaction.
>
> - where can i get information about the required
> information
> (i mean: basic required files, registry changes, conf
> files,
> sql commands to do what i need) ?
>
> - if this is not possible, may i call the default
> PostGre's
> installer in silent mode ? and if so, what are the
> command-lines
> to set the defaults settings ?
>
> - can any of you help me in any of those tasks ?
>
> thanks in advance,
>
>
>
>
>
>
> __________________________________________________
> Pregunt=E1. Respond=E9. Descubr=ED.
> Todo lo que quer=EDas saber, y lo que ni imaginabas,
> est=E1 en Yahoo! Respuestas (Beta).
> =A1Probalo ya!
> http://www.yahoo.com.ar/respuestas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

=2D-=20
Darcy Buskermolen
CommandPrompt, Inc.	=09
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
http://www.commandprompt.com