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

Oracle DBMS SCHEDULER Examples

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

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to Enable/Disable autovacuum on PostgreSQL