anamika
23rd February 2009 16:32 UTC

silent postgreSQL installation
Hello,

I have tried the following command line argument for silent postgreSQL installation.

msiexec /i "Z:\InstallJimmer\postgresql\postgresql-8.3.msi" /qf INTERNALLAUNCH=1 SERVICEPASSWORD="anamika21" CREATESERVICEUSER=1 SUPERPASSWORD="anamika" ENCODING=UTF8 ADDLOCAL=server,psql,pgadmin

i gave /qf options and it is working but still i need to set the language,superusername ,passord and other settting.

now i want it to be done in silent mode so the option wud be /q but i dont know how to set the authentification,language,encoding ,passord at command line.

please tell me how can i do that?

ginglese
25th February 2009 13:51 UTC

here is how i do it :

SetOutPath "$INSTDIR\PostgreSql"
ExecWait '"$INSTDIR\PostgreSql\installSql.bat" "$INSTDIR"'

with installSql.bat as :
net user postgres adminwaves /passwordreq:yes /PASSWORDCHG:no /add
NETUSER.exe postgres /pwnexp:y
msiexec /i "%~1\PostgreSql\postgresql-8.2-int.msi" /log "c:\logpost.txt" /qb! INTERNALLAUNCH=1 ADDLOCAL=server,psql,pgadmin SERVICEDOMAIN="%COMPUTERNAME%" SERVICEPASSWORD=adminwaves SUPERPASSWORD=1234 ENCODING=UTF8 PERMITREMOTE=1 NOSHORTCUTS=1 BASEDIR="c:\postgres"

for the language use this parameter :
TRANSFORMS=:lang_de (see http://pginstaller.projects.postgresql.org/silent.html)

anamika
4th March 2009 13:10 UTC

thx for your reply.
I am first trying it at command prompt with the following options.

msiexec /i "Z:\InstallJimmer\postgresql\postgresql-8.3.msi" /log "c:\result.txt" /quiet INTERNALLAUNCH=1 DOINITDB=1 DOSERVICE=1 ADDLOCAL=server,psql,pgadmin SERVICEDOMAIN="%COMPUTERNAME% SERVICENAME="PostgreSQL Database Server 8.2" LISTENPORT=5432 SERVICEACCOUNT="postgres" SERVICEPASSWORD="12pgroot5" SUPERUSER="pgroot" SUPERPASSWORD="12pgroot5" BASEDIR="c:\postgres" TRANSFORMS=lang_de

but actually its not doing anything instead of showing the help menu.
Could you please tell me if thr is something wrong in the options.

kichik
14th March 2009 22:57 UTC

Can someone please create a Wiki page for this? It gets asked quite a lot.