Thread: running PostGres without installing it

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)
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á. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas

On 8/6/06, jesus martinez <jesus_martinez1967@yahoo.com.ar> 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:

I've done it, it's not to difficult.  In fact, if you check the
archives you might find a tutorial.  The hard part in windows is
launching a cmd process to initdb the database since it can't run as
administrator.  I had to use a program called 'sanur' to allow me to
feed the password to runas.

Also check out ntrights.exe to grant logon as service right and the
'net' command to add a user.

Have you looked at silent mode install with standard installer?

merlin

On 8/6/06, jesus martinez <jesus_martinez1967@yahoo.com.ar> wrote:
>
> Merlin, first all, thanks for taking time to
> answer me.
>
> - where do i have to find the tutorial you
> said ? do you have the URL ?

http://pginstaller.projects.postgresql.org/silent.html

> - i actually didnt try the silent-mode.
>  because the regular installers i know not always
>  publish their command-line options...
>  where can i get them ?
>
> finally, is it to much to ask you if you could
> send to me the script-file of your installer ?
> (if you cant i will understand)

don't work at that company anymore, sorry =)
merlin