Re: beginner: what permissions required to install on windows 2000+ - Mailing list pgsql-general

Harald,

Thanks for the response.

>1.) you should prefer windows 2003 for your first PostgreSQL install
> on windows. Installation on Windows 2000 is a lot more challenging.
> BTW: main stream support for 2000 by Microsoft ended on 2005-06-30, so
> unless you have contracts with MS for extended support...

Yes, you are right. Unfortunately, I am stuck with an old 2000 box for the moment. Though hopefully I will move it to one with a newer o/s in the near future.

> 2.) please be very carefull about the different permissions for
> "INSTALLING" and "RUNNING" PostgreSQL on windows

Understood

> So, to drill down to your problem:
> a) when did you get this error? During installation? That would point
> more to problems with wrong version of installer, broken MSI-files....

The error occurs during the installation of version postgresql-8.3.msi (8.3.0-1). 

- I was logged in as a user with admin rights. Firewall s/w was disabled.
- In case that was not sufficient, I also tried the installation while logged in as the Adminstrator and after completely uninstalling firewall s/w.  The same errors occur.

I have tried 2 approaches:

1) I accepted all of the default settings and allowed the installation program to create the windows-user postgres.  An error occurs when the program reaches the status point "Starting services":

"The application failed to initialize properly (0xc0000022). Click on OK to terminate the application."

I have included a snippet from the installation log and a message from the windows event log below.

2) I also tried creating the local user acccount before the installation. 
- I deleted the previous windows account and created a new one
- I granted the account "Log on Locally" and "Log on as service rights".
- When I try and run the installation again, I receive the error message
"Invalid username specified: A required privilege is not held by the client"

==== start: snippet from error log ==============================================================
Action 0:17:48: StartServices. Starting services
MSI (s) (BC:98) [00:17:48:875]: Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000)
MSI (s) (BC:98) [00:17:48:875]: Executing op: ServiceControl(,Name=pgsql-8.3,Action=1,Wait=1,)
StartServices: Service: PostgreSQL Database Server 8.3
MSI (c) (E4:E0) [00:20:45:062]: Note: 1: 2205 2:  3: Error
MSI (c) (E4:E0) [00:20:45:062]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2888
DEBUG: Error 2888:  Executing the TextStyle view failed
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2888. The arguments are: TextStyle, ,
Action 0:20:46: Cancel. Dialog created
MSI (c) (E4:E0) [00:21:01:421]: Note: 1: 2205 2:  3: Error
MSI (c) (E4:E0) [00:21:01:421]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2888
DEBUG: Error 2888:  Executing the TextStyle view failed
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2888. The arguments are: TextStyle, ,
MSI (s) (BC:98) [00:21:20:843]: Note: 1: 2205 2:  3: Error
MSI (s) (BC:98) [00:21:20:843]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1920
MSI (s) (BC:98) [00:21:20:875]: Note: 1: 2205 2:  3: Error
MSI (s) (BC:98) [00:21:20:875]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709
MSI (s) (BC:98) [00:21:20:875]: Product: PostgreSQL 8.3 -- Error 1920. Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start.  Verify that you have sufficient privileges to start system services.

MSI (s) (BC:98) [00:21:20:890]: Note: 1: 2205 2:  3: Error
MSI (s) (BC:98) [00:21:20:890]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1602
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2205 2:  3: Error
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2835
DEBUG: Error 2835:  The control ErrorIcon was not found on dialog ErrorDlg
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2835. The arguments are: ErrorIcon, ErrorDlg,
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2205 2:  3: Error
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2888
DEBUG: Error 2888:  Executing the TextStyle view failed
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2888. The arguments are: TextStyle, ,
Are you sure you want to cancel?
==== end: snippet from error log ==============================================================


==== start: event log message ==============================================================
Event Type:    Error
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7005
Date:        3/4/2008
Time:        12:20:50 AM
User:        N/A
Computer:    DEV
Description:
The LoadUserProfile call failed with the following error:
Access is denied. 
==== end: event log message ==============================================================

---

Looking for last minute shopping deals? Find them fast with Yahoo! Search.