Thread

1. FW: Unable to install PostgreSQL on Windows Server 2003 SP2

   William <whairs01@hotmail.com> — 2010-02-24T12:57:54Z

   Hello Pqsql-hacker,
   
   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. if not why will it not
   install. I have tried everything but will not install. That is why I am here
   asking you hoping you can get me past this. Following is the installer log
   files that shows everything that went on during the install. I need to know
   from you what I need to do exactly to fixed the problem in get this to
   install on my server that is hosted are a Host provider. No one have being
   able to help. I need an answer ASAP if possible
   
     		 
   The server is a VPS server with the following configuration:  (is this
   support or is the problem)
   *	OS:        Windows Server 2003 Datacenter Edition SP2
   *	CPU:     2.5Hz. Xeon
   *	Ram:    4GB
   *	HD:       100GB
   *	Control Panel: Plesk 9.3
   
   I really need your help to get pass this. This system is at a Hosting
   Company which I Remote Logon to it to install the PostgreSQL. Is there a
   problem during it this way. Need your respond ASAP.
   
   
   Regards,
   
   William Hairston - Partner/CIO
   2Continents, LLC
   Office: 510-342-5900 (USA),
   Office: (+86)021-5306-3065 (China)
   Mobile: (+86)131-2233-4698
   
   
   

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

   Dave Page <dpage@pgadmin.org> — 2010-02-24T13:50:54Z

   On Wed, Feb 24, 2010 at 12:57 PM, William <whairs01@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