The following bug has been logged on the website:
Bug reference: 12728
Logged by: James Slade
Email address: james.slade@maersk.com
PostgreSQL version: 9.3.5
Operating system: Window 7 64 bit.
Description:
Problem:
An issue for installing on corporate machines running McAfee VirusScan
Enterprise. The bug is in the IsPathWritable function of the
prerun_checks.vbs script.
There is a âbugâ in one of the installation scripts for PostgreSQL. In order
to ascertain if the %TEMP% directory is writable it attempts to create a
file. In doing so it tries to create a file with a double extension
âc:\temp\xxxx.tmp.tmpâ which triggers a McAfee rule that blocks the action.
Workaround 1:
Uninstall McAfee VSE while installing PostgreSQL then re-install McAfee.
Workaround 2:
Run the PostgreSQL with ââextract-only 1â on the command line. It will
extract all the files without doing the above check. We can then bypass the
check and replicate the setup process by running the following commands:
⢠"C:\Program Files\PostgreSQL\9.3\installer\vcredist_x64.exe"
/passive /norestart
⢠cscript //NoLogo "C:\Program
Files\PostgreSQL\9.3/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****" "C:\Program
Files\PostgreSQL\9.3" "C:\Program Files\PostgreSQL\9.3\data" 5432 "DEFAULT"
0
⢠cscript //NoLogo "C:\Program
Files\PostgreSQL\9.3\installer\server\startupcfg.vbs" 9.3 "NT
AUTHORITY\NetworkService" "****" "C:\Program Files\PostgreSQL\9.3"
"C:\Program Files\PostgreSQL\9.3\data" "postgresql-x64-9.3"
⢠cscript //NoLogo "C:\Program
Files\PostgreSQL\9.3\installer\server\createshortcuts.vbs" 9.3 "postgres"
5432 "PostgreSQL 9.3" "C:\Program Files\PostgreSQL\9.3" "C:\Program
Files\PostgreSQL\9.3\data" "postgresql-x64-9.3"
⢠cscript //NoLogo "C:\Program
Files\PostgreSQL\9.3\installer\server\startserver.vbs" postgresql-x64-9.3
⢠cscript //NoLogo "C:\Program
Files\PostgreSQL\9.3\installer\server\loadmodules.vbs" "postgres" "****"
"C:\Program Files\PostgreSQL\9.3" "C:\Program Files\PostgreSQL\9.3\data"
5432