Ever since we moved to the versions where postgreSQL 9.6 is used my Qlik sense installation fails. I've tried everything I could find on the community without much results. The best result I've got is to manually install PG9.6 and setup everything manually but I think the installer should work and there might be something wrong with my system. I've tried all versions up until November 2017. The Windows version is 2016 fully patched clean install. Does anyone have a clue how to fix this?
The general log says this:
[01DC:0DD4][2018-02-13T13:25:45]e000: Error 0x80070643: Failed to install MSI package.
[01DC:0DD4][2018-02-13T13:25:45]e000: Error 0x80070643: Failed to execute MSI package.
[09A4:12D8][2018-02-13T13:25:45]e000: Error 0x80070643: Failed to configure per-machine MSI package.
Action 13:25:42 31 InitDB call failed with exit code 1.
CustomAction CA_InitDB returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
This suggests that the initdb call has failed. Since there are functionally only 2 parameters, does C:\ProgramData\Qlik\Sense\Installation\postgresql\ps_qlik.bin contain the password to the postgres user?
I mean, in a pinch, you can always change md5 to trust in the pg_hba.conf file in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.x\ directory which will implicitly trust the connection from the local loopback and bypass the pwd validation parameter. The pain here is that to reset things back require a bit of work.