[postgis-users] Installing postgis from an NSIS installer

[Yves Moisan]

> > MessageBox MB_YESNO "Install PostgreSQL 8.3.5?" /SD IDYES IDNO endPG835
> >     File "..\postgresql\postgresql-8.3-int.msi"
> >     ExecWait '"msiexec" /i "postgresql-8.3-int.msi" /qr INTERNALLAUNCH=1
> > SERVICEACCOUNT="postgres" \
> >       SERVICEPASSWORD="xyz" CREATESERVICEUSER=1 SUPERUSER="postgres"
> > SUPERPASSWORD="xyz" LISTENPORT=5433 \
> >       PERMITREMOTE=1 ENCODING=latin1 BASEDIR="$INSTDIR\postgresql"
> > TRANSFORMS=:lang_fr'
> >   endPG835:
> > 
> >   MessageBox MB_YESNO "Install PostGIS 1.3.5 for 8.3.5?" /SD IDYES IDNO
> > endPostGIS
> >     File "..\postgis\postgis-pg83-setup-1.3.5-1.exe"
> >     ExecWait "$INSTDIR\postgis-pg83-setup-1.3.5-1.exe /D=$INSTDIR
> > \postgresql"
> >   endPostGIS:

> 
> Hi Yves,
> 
> You can download a zip-file containing the GPL'd source for the Win32 
> installer from here: 
> http://pgfoundry.org/frs/?group_id=1000256&release_id=1274. This should 
> then answer all your questions :)
> 

Hi Mark,

I can see the postgis.nsi file and all it depends upon, but what I'm
most interested in is just calling the generated installer file (.exe)
from within my own installer.  An Exec command on the postgis...exe
should work.  

In fact, I'm guessing the way I install postgresql (access of the
postgres account, file persmissions ??) to begin with has problems
because the postgis installer chokes even if I do it directly (out of my
NSIS script).  I've installed postgis many times but it is the first
time I get a message warning me of the existence of a database object
that does not exist.  

I read that the postgres user should have an "edit database object"
permission (saw that on a Django list) but I can't find that in pgAdmin.
I'll keep looking at the code to see if I can find the answers I'm
looking for.

Thanx,

Yves