Re: Access is denied during initdb - Mailing list pgsql-general

From Richard Huxton
Subject Re: Access is denied during initdb
Date
Msg-id 42B7C9FE.8050202@archonet.com
Whole thread Raw
In response to Re: Access is denied during initdb  ("O.B." <postgres@dafunks.com>)
List pgsql-general
O.B. wrote:
> Richard Huxton wrote:
>
>> O.B. wrote:
>>
>>> Here's additional information from the log file surrounding the
>>> problem with initdb failing:
>>>
>>> Action 18:10:09: SetPermissions. Setting filesystem permissions...
>>> MSI (s) (2C:AC) [18:10:09:323]: Executing op:
>>>
CustomActionSchedule(Action=SetPermissions,ActionType=1025,Source=BinaryData,Target=SetPermissions@4,CustomActionData=1033;C:\PostgreSQL\8.0\;C:\PostgreSQL\8.0\data\;DA15666;postgres;mypassword)

>>>
>>> MSI (s) (2C:30) [18:10:09:339]: Invoking remote custom action. DLL:
>>> C:\WINDOWS\Installer\MSI50.tmp, Entrypoint: SetPermissions@4
>>> MSI (s) (2C:AC) [18:10:12:619]: Executing op:
>>> ActionStart(Name=RunInitdb,Description=Initializing database cluster
>>> (this may take a minute or two)...,)
>>> Action 18:10:12: RunInitdb. Initializing database cluster (this may
>>> take a minute or two)...
>>> MSI (s) (2C:AC) [18:10:12:619]: Executing op:
>>>
CustomActionSchedule(Action=RunInitdb,ActionType=1025,Source=BinaryData,Target=RunInitdb@4,CustomActionData=1033;C:\PostgreSQL\8.0\;C:\PostgreSQL\8.0\data\;5432;;C;SQL_ASCII;postgres;testdb;DA15666;postgres;mypassword)

>>>
>>> MSI (c) (40:58) [18:10:15:556]: Note: 1: 2205 2:  3: Error
>>> MSI (c) (40:58) [18:10:15:556]: 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, ,
>>
>>
>>
>> Presumably this is the problem.
>>
>> If no-one seems to know here, perhaps try the windows installer
>> project. They will be able to tell you what can cause this error.
>>   http://pgfoundry.org/projects/pginstaller/
>
>
> I just installed PostgreSQL 8.0 with the "service" registration option
> disabled and tried to execute the following and it fails with the same
> error.
>
> runas.exe /env /user:DA15666\postgres "C:\PostgreSQL\8.0\bin\initdb.exe
> -D C:\PostgreSQL\8.0\data"
>
> So the problem is not with the installer but either with initdb or how
> my system is configured.  Help?

The error you are giving is *not* an initdb error, or from any other
part of PostgreSQL proper (I can find no error with 2888 or TextStyle
anywhere in the source). It also explicitly mentions MSI, which is
Microsoft's installer, as well as initdb.

 From the list archives, most problems seem to be either:
  1. Some anti-virus package blocking the install
  2. Too few or too many permissions (PG won't run as a superuser).

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: postgresql@bryden.co.za
Date:
Subject: Scripting issues
Next
From: peter pilsl
Date:
Subject: renumber id's in correct order (compact id's)