Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Unattended Mode Installation

 I am using Postgres 9.3.3.1 on Windows (32-Bit Windows 7 Professional).
 I use the installer executable postgresql-9.3.3-1-windows.exe with the
 option "--optionfile <file>"> 
The option file has the following content (the ${..} are replaced with correct
 #mode=unattended
 datadir=${program.base}data
 prefix=${program.base}
 serverport=${postgres.port}
 superaccount=postgres
 superpassword=${postgres.passwd}
 unattendedmodeui=minimalWithDialogs
 servicename=${postgres.service.name}
1) If the "mode" property is enabled to mode=unattended, the installation
works silent but the whole 'data' folder is missing after installation (the first
error message will occur when the server-startup failes after installation).
2) If the "mode" property is disabled, the Installer interface appears.
Everything is correctly set, I need only to press the <next> button. The
Installation completes correctly.

Why does my unattended installation as described in 1) fail, but 2) succeeds?
Here are options that I use for unattended install (and it creates cluster with Postgres, template0, and template1 databases, which means data directory and all its subdirectories are created too):
SET INSTALLOPTIONS=--unattendedmodeui none
SET INSTALLOPTIONS=%INSTALLOPTIONS% --mode unattended

Also, you are missing settings for servicesaccount, servicepassword, and locale, e.g.:
SET INSTALLOPTIONS=%INSTALLOPTIONS% --locale C
SET INSTALLOPTIONS=%INSTALLOPTIONS% --serviceaccount postgres
SET INSTALLOPTIONS=%INSTALLOPTIONS% --servicepassword pg_password123
In general, to diagnose (silent or not) installation problems find "bitrock" installer log somewhere under DocumentsandSettings for OS user that runs installation.



Comments

Popular posts from this blog

Ora2PG - Oracle/MySQL to Postgres DB migration Version 20.0

spfile and pfile errors

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

How to Return a Result Set from a PostgreSQL Stored Procedure

PostgreSQL New version upgrade