Обсуждение: FW: Unable to install PostgreSQL on Windows Server 2003 SP2

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

On 24/02/10 13:09, William wrote:
> Hello Pqsql-hacker,
>
> I have tried everything and ask many but cannot get my Installation of your
> PostgreSQL 8.4.1.1 to install.

While you are having problems, take the opportunity to download 8.4.2 
and work with that. That's the latest set of bugfixes.
> 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.

Have you read the logs? Searching for "Error" is the best way to start.

The first occurrence in bitrock_installer.log is at line 3244. If you 
read the 20 or so lines before that you will see that is says it 
installed everything:  Success. You can now start the database server using...
It then fails when trying to grant access to the data directory for your 
service account (the user the database runs as).  Granting service account access to the data directory (using cacls):
processeddir: 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)
 
After that, you get more errors because the service couldn't be started.

The second logfile is identical to the first.

So - either there is a bug in the installer, or your administrator 
account in the virtual server doesn't have permission to do this 
installation properly. Doesn't matter which from your point of view. I'm 
not a Windows expert regarding PostgreSQL, but there are some obvious 
things to try.

First thing to do - check if PostgreSQL is still installed and that you 
have a data directory in D:\APPS\PostgreSQL\8.4\data.

If so, try granting permission on that data directory to the "postgres" 
user manually. Just right-click the folder and add full rights for 
"postgres". You should then be able to start the service manually (I 
think there is a menu item - if not it will be in the services control 
panel).

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.

If you didn't find the data directory, create it, grant permissions to 
"postgres" and then try a full re-install.

--   Richard Huxton  Archonet Ltd

On Wed, Feb 24, 2010 at 8:15 PM, Richard Huxton <dev@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