Install Postgre while installing Other software.

On 07/02/2009 15:40, I�igo Barandiaran wrote:

I'm trying to use Postgre as a DataBase manager of a Software I'm
developing. I would like to know how to integrate an installation of Postgre
in the installation of my own software. I mean, I need to firstly install

The community installer (pgInstaller) has a silent-install option which
I understand is intended for just this scenario.

BTW, the accepted abbreviation of PostgreSQL is "postgres", not "postgre".

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Hi Raymond!

Thanks for your answer. I'm going to take a look to the silent option you
mentioned.
Any link related with this topic would be very appreciated.

Thanks in advance!

Best,

2009/2/7 Raymond O'Donnell <rod@iol.ie>

Hi.

I've found this page about silent install that was very usefull for me:
http://pginstaller.projects.postgresql.org/silent.html

Now, I've found another problem. I'm able to install PostgreSQL with my
software in silent mode, but the problem comes when I do un-install. The
problem is related with service account.
I'm currently using the followin settings for install:

*msiexec /i postgresql-8.3-int.msi /qr INTERNALLAUNCH=1 DOINITDB=1
CREATESERVICEUSER=1 ADDLOCAL=server,psql,pgadmin BASEDIR="c:\postgres"
SERVICEDOMAIN="%COMPUTERNAME%" SERVICEPASSWORD="AnyPassWord" SUPERPASSWORD="
**AnyPassWord2****" *

If I do un-install the service account is not removed, so next time I try to
install the software again the service account name (posgres) exists so It
can not be created again, so the installation progress stops, rolling back.
Do you know how can I remove posgres service account while un-installing? or
maybe Do you know how to chek if the postgres user exist while installing,
so therefore the installation process could create or login with that user?

Thank in advance!

2009/2/7 Iñigo Barandiaran <ibarandiaran@vicomtech.org>

Iñigo Barandiaran wrote:

If I do un-install the service account is not removed, so next time I
try to install the software again the service account name (posgres)
exists so It can not be created again, so the installation progress
stops, rolling back.
Do you know how can I remove posgres service account while
un-installing? or maybe Do you know how to chek if the postgres user
exist while installing, so therefore the installation process could
create or login with that user?

NET USER POSTGRES /DELETE

or some sort of WSH WMI magic....

the problem with reusing an existing service account, you don't know its
password

silly question, what will your installer do if there is a preexisting
Postgres install on the target system?

Thank you all for your answers!.

This solve one of my problems :) THANKS!!!

John, thats a very good question. I've already thought about that, but I've
no idea how to act yet. Becuase, as you said, if there is already a posgre
Database server installed in the target system, and I dont know the
password, what can i do? I can not delete the existing user account because
I would be affecting other software. What about if I create another service
user account, with a different name, such as MyPostgreUserAccount? That way
I ensure that I'm creating/deleting the Postgre User of my application. What
do you think?

Thanks in advance!!

2009/2/8 John R Pierce <pierce@hogranch.com>

Hi John.

Thanks for your comment.

You are right. I als think that option *A* is the best, but the problem, as
you mentioned, it is only suitable for knowlegeable, that I might is not
the general case. The "normal" end user only wants to use the software
without knowing anything about data bases etc. I think the only suitable
option is *C*, taking into account that maybe is not the most efficient, in
terms of memmory or disc consumptions.

And thanks for the comment about IO port. You are right. If we installl a
separate paralell distribution, we should change the IO port defined by
default.

Thanks again!!!!!!!!

2009/2/8 John R Pierce <pierce@hogranch.com>