running PostGres without installing it

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

running PostGres without installing it

jesus martinez-4
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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Reply | Threaded
Open this post in threaded view
|

Re: running PostGres without installing it

Reini Urban
jesus martinez schrieb:
> hello, how are you ?

We don't care.

> 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:

This will be hard for you, since you even cannot spell the name of the
program right. How do you want to support your clients then?

> 1) install the PostGres's required files
> 2) modify the system as PostGres needs (registry,
> paths, etc)

postgresql on cygwin needs no regisztry entries, cygwin needs the mount
points in the registry which will created automatically if you do the
setup via the official way. Don't ask here, how to install a cygwin
package. Read the webpage instructions at http://cygwin.com/

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

Very simple tasks for someone who knows postgresql.

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

No registry changes besides the mount points for cygwin are needed,
if you really want to go this way. But if you do that, the cygwin
mailing list will not help you or your clients. Then you have to give
them support.

Search the mailing lists, here and cygwin at cygwin.com for silent
cygwin installs.
I believe someone has done it for rsync and ssh installations already,
but didn't post his install script (for the nsis installer if I remember
correctly) publicly. You have to ask him.

The rest is your work alone and -cygwin is the inappropriate list for
such basic SQL tasks. Maybe the pgsql-novice list will help you.

> - 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 ?

No. You want win98, which is not supported by the native build.
You have to use the cygwin package which is installable via
http://cygwin.com/setup.exe

> - can any of you help me in any of those tasks ?

Sorry, doing this automatically is a major task and I don't have time in
helping there.
If you managed to do that, we will be very happy to receive your install
script.
--
Reini - voluntary postgresql-cygwin maintainer

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster