Re: FW: Unable to install PostgreSQL on Windows Server 2003 SP2

On Wed, Feb 24, 2010 at 12:57 PM, William <whairs01(at)hotmail(dot)com> wrote:
> Hello Pqsql-hacker,

This isn't a question for -hackers. Please use the general list in future.

> I have tried everything and ask many but cannot get my Installation of your
> PostgreSQL 8.4.1.1 to install. I following all the steps exactly but I
> cannot get the  PostgresSQL to install on my Windows Server 2003 Datacenter
> Edition SP2. Is there a problem in installing the PostgreSQL on this version
> of Windows which is Hosted at a Host Provider.

That depends if the hosting provider has setup things oddly in any
way. It should certainly work on a standard installation of 2K3
Datacenter.

Unfortunately you've fallen over a weird issue with one of the
Microsoft tools that crops up very occasionally, and we've yet to find
the cause (or even be able to recreate it) :-(. The pertinent part of
the log is this:

----
Granting service account access to the data directory (using cacls):
processed dir: D:\APPS\PostgreSQL\8.4\data
The data is invalid.

Failed to grant service account access to the data directory
(D:\APPS\PostgreSQL\8.4\data)
----

Notice the rather unhelpful 'The data is invalid' error, returned by cacls.exe.

My first suggestion would be to run a disk check (no need for a sector
scan) on your D drive. If the problem is being caused by a damaged ACL
on a parent directory, that should clean it up. If that doesn't work,
please send the output from the following commands:

cacls D:\APPS\PostgreSQL\8.4\data
cacls D:\APPS\PostgreSQL\8.4
cacls D:\APPS\PostgreSQL
cacls D:\APPS
cacls D:\

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do