FW: Unable to install PostgreSQL on Windows Server 2003 SP2
in [PgSql]
|
Prev: [HACKERS] Typo in online docs
Next: [COMMITTERS] pgsql: Un-break pg_dump for the case of zero-column tables.
From: Dave Page on 24 Feb 2010 08:50 On Wed, Feb 24, 2010 at 12:57 PM, William <whairs01(a)hotmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Dave Page on 24 Feb 2010 16:33
On Wed, Feb 24, 2010 at 8:15 PM, Richard Huxton <dev(a)archonet.com> wrote: > If that all works, re-run the installer and you should be able to re-install > the adminpack etc. over the top of your now working installation. That won't work. If the installer finds the existing data directory (which it will), it won't try to run initdb or modify it in any way. It'll just check the catalog version and datetime format are compatible. You'd have to run the adminpack SQL script manually. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |