BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long

From: gtsal(at)intracom(dot)gr
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long
Date: 2012-10-30 10:54:53
Message-ID: E1TT9TB-0001J3-F5@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7628
Logged by: George Tsaloukidis
Email address: gtsal(at)intracom(dot)gr
PostgreSQL version: 9.2.1
Operating system: Windows 7 Home Premium 64-bit, SP 1
Description:

Dear All,

I downloaded setup file postgresql-9.2.1-1-windows-x64.exe
from your web site, and tried to install PostgreSQL on my machine.
Before finishing, one-click installer displayed the message
“initializing the database cluster” and stayed there for hours.

Using perfmon.exe tool I found that there was a lot of disk activity
and that program icacls.exe were accessing a lot of files contained
in some personal folders. Selected installation directory was
“C:\Program Files\PostgreSQL\9.2”.

Search on the web revealed that installer uses icacls.exe to change access
permissions on installation directory. However in my case, files accessed
by icacls.exe had nothing to do with installation directory.

The next step was to check file
“C:\Program Files\PostgreSQL\9.2\installer\server\initcluster.vbs”.
That script calls icacls.exe for all folders consisting
installation directory except for “C:\” and “C:\Program Files”
(if they are part of installation directory). Unfortunately,
instead of accessing %SYSTEMDRIVE% environment variable, script tries
to get the value of %SYSTEMDRIVER%, which does not exist.
So system’s root directory is not really excluded and if it contains
a lot of file (as mine), the installation may need some hours.

To check it, I defined a new environment variable
(SYSTEMDRIVER=%SYSTEMDRIVE%)
and ran the setup program again. This time installation finished within a
couple of minutes.

Best Regards,
George.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message dmigowski 2012-10-30 11:49:21 BUG #7629: Suboptimal query plan when index search is possible and an additional search operator is given.
Previous Message Simon Riggs 2012-10-30 09:23:17 Re: BUG #7627: Bad query plan when using LIMIT