Addressing the #agilecentral defect DE136282 with this KB article.
When I install the Enterprise Manager (EM), the installation sometimes fails because the Postgres installation hangs. There are two reasons this might happen:
Postgres Database Installation Timeout
Symptom
When I installed Enterprise Manager, the installation completes with database creation failures. Upon investigation, I found that the installer got timed out due to Postgres database installation taking longer than acceptable. On further investigating I found that the Postgres Database eventually started, but APM DB schema is not created.
Solution
Manually uninstall the partial installation of the Postgres database, so that any instance of Postgres is removed from your server. Now install the Postgres database using the CA APM installer by selecting the DB Only installation option in the Choose the install Set screen.
Postgres Database Installation Stuck
Symptom
When I installed Enterprise Manager, the installation never completes. Upon investigation, I found that the installer hangs due to the Postgres database installer. On further investigating I found that the EM installation hangs due to Postgres database installation stuck running validateuser.exe process.
Solution
Manually end both Postgres and Enterprise Manager installation processes from the Task Manager and restart CA APM installer again.