PostgresQL 8.3.9 installer consistently failing on Vista

This message was edited 1 time. Last update was at 24 Feb 2010 04:21:15

Hello,
Been trying over the past 6 days to install your one click installer 8.3.9 on Vista to evaluate the product for my company. Have read near about every post on the forum including those where other users suffered similar issues. Close to the end of the installation, it states that it cannot access data/postgres.conf. When trying to run initdb manually (after running the cmd prompt as user postgres) I get a initdb failed to initialize cluster error popup. Looking at the event log it gives me the following:

Log Name: Application
Source: Application Error
Date: 24/02/2010 14:42:00
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: xxx
Description:
Faulting application initdb.exe, version 8.3.9.9343, time stamp 0x4b20ff4a, faulting module ntdll.dll, version 6.0.6001.18000, time stamp 0x4791a7a6, exception code 0xc0000374, fault offset 0x000b015d, process id 0x217c, application start time 0x01cab5316bb01418.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2010-02-24T09:12:00.000Z" />
<EventRecordID>28773</EventRecordID>
<Channel>Application</Channel>
<Computer>xxx</Computer>
<Security />
</System>
<EventData>
<Data>initdb.exe</Data>
<Data>8.3.9.9343</Data>
<Data>4b20ff4a</Data>
<Data>ntdll.dll</Data>
<Data>6.0.6001.18000</Data>
<Data>4791a7a6</Data>
<Data>c0000374</Data>
<Data>000b015d</Data>
<Data>217c</Data>
<Data>01cab5316bb01418</Data>
</EventData>
</Event>

My installation log is below. All went well except for the end of the install process wherein I got

[14:33:33] Write the data directory to the ini file...
[14:33:33] Write the port number, service ID, locale and superuser to the ini file...
Problem running post-install step. Installation may not complete correctly
Error reading file C:/Program Files/PostgreSQL/8.3/data/postgresql.conf

Have tried changing the permissions on the Program Files/Postgres directory to allow full control to user postgres. Have also tried to install other versions including the non-one click installers. Can't seem to get any other solution have looked throughout the net both on this forum and the postgres classic forums. Could someone please help as need to submit an evaluation soon?

Regards,
G.

Hello,

What exactly is the error message when you run initb manually? (also give the command you run)

Hi Sachin,
After I got the "Error reading file C:/Program Files/PostgreSQL/8.3/data/postgresql.conf" towards the end of the installation, I did the following

1) Ran the cmd as user postgres

2) Ran initdb to initialize the db cluster.

Tried both:

and

In both cases, I get a Windows Popup saying "initdb - initialize a new database cluster has stopped working" with a "Close the Program" button.

The Vista Event Log gives the following error:
"Faulting application initdb.exe, version 8.3.9.9343, time stamp 0x4b20ff4a, faulting module ntdll.dll"

Appreciate your help in getting this working..
Regards.
gr.

Any luck with this, guys? Attaching the install log as well for your perusal in case you need it. Since initdb fails immediately without logging anything, i feel there's some incompatibility somewhere, maybe a conflicting driver or something....

Please review this log and my previous reply and appreciate any help you can offer us here.

Cheers,
gr

Hi,

Please try this installer : http://uploads.enterprisedb.com/download.php?file=74f8a585020690e1abe133259020104b

Please clean up your system before starting. Uninstall previous installations and cleanup the previous directory.

--
Regards,
Dharmendra Goyal
EnterpriseDB , the Enterprise Postgres company.

Hello dharmendra,
Tried this and got the same exact errors. First I got the "Error reading file C:/Program Files/PostgreSQL/8.4/data/postgresql.conf" during installation followed by the "InitDB failed to initialize database cluster" popup when I tried to run initdb manually. Am beginning to think that its impossible to install this on Vista.

Could any of you please help as we need to evaluate this for my business urgently, prefer xTuple to Openbravo and it requires this to install.

The log file from the latest install is attached.

And here's the Vista Event Manager Log

Faulting application initdb.exe, version 8.4.2.1050, time stamp 0x4b805a11, faulting module ntdll.dll, version 6.0.6001.18000, time stamp 0x4791a7a6, exception code 0xc0000374, fault offset 0x000b015d, process id 0xb80, application start time 0x01cab78e6dc04bf3.

I cant find anything useful in the log.

By looking at vista event manager log this seems to be a vista issue. Please check following forum for same error:
http://www.vistax64.com/vista-general/240691-faulting-module-ntdll-dll.html

As final comments say:
It seems to be some incompatibility in ntdll.dll between XP and Vista
versions.

Hi Dharmendra,
Thanks for your reply. What does this have to do with XP? Are we saying something in the PostgreSQL 8.4 is incompatible with Vista. Would overwriting the Vista ntdll.dll with an alternate file help? I've only ever had this error with initdb.exe - even when I launch it in debug mode I get the error popup immediately. Would reinstalling the C++ libraries help at all or is this a driver conflict? Appreciate any clarity you could offer here, I'll keep trying to get this to work..

Regards,
GR

Hello, have the same post-install error on Win7 x64.

Try using a directory other than the default for data... try 'c:\pgdata'

Does it help?

Unfortunately it didn't help