Postgres install error message: "Unable to write inside TEMP environment variable path."

Document ID : KB000032762
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

Attempting to upgrade our APM from 10.0 to 10.1 while following the CA APM documentation.

I am at the step to install the Postgres database.  

When trying to install the database, it gives an "Unable to write inside TEMP environment variable path" error.

At the end, it gives three more messages about log files having the error messages on the failed install.

Schematools.log shows

"[ERROR] [main] [root] [UpgradeSchema] - Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IPconnections. org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections." 

 

Environment:

Windows 2008 R2

 

Cause:

The PostgreSQL installer portion of the EM installer tries to write a tmp.tmp file.

This type of file is most commonly associated with malware and McAfee blocks it from writing as part of its access protection. 

11/11/2015 10:12:11 AM Blocked by Access Protection rule C:\WINDOWS\SYSTEM32\CSCRIPT.EXE D:\temp\2\radE3145.tmp.tmp Rules:Prevent TMP.TMP file creation Action blocked : Create

 

Workaround:

Disable the McAfee access rule temporarily and the APM database installer will complete.