Postgresql Plus does not install service/data directory

This message was edited 3 times. Last update was at 2 Sep 2010 14:29:57

Hi,

I'm having major issues with the Postgresql Plus 8.4 installer and looking for help!

I go through the installation, and it never seems to complete correctly. I've searched the forums and have not found any solution that seems to help. Here is where I am at:

1. It is being installed on Win2k3 Server 64 bit SP2
Instead of installing as Domain Admin, I created a local user and added to local Administrators group. logged on and installed as the local user
2. I am performing the install through MSTSC using /admin and /console switches. Session ID=0
3. I executed installer through the command prompt and set SESSIONNAME=Console first.
4. Originally tried having data file on D Drive, but also tried default location, and still does not work.
5. Verified "Users" group has read access to all directories leading up to install directory.

I am attaching all the log files I have pertaining to this issue. Is there instructions available to install PostgreSQL without the installer?

I chose only the Database to install, and excluded all the additional applications to try to determine where the problem was. I get no errors during the installation and once done, there is no service listed under services.msc, and the "data" directory is created, but empty.

I also exected " initdb -E UTF-8 -U postgres ..\data" manually, and the data files were created, but the postgres service was not. Not sure if I can manually create the service.

Thanks in advance for any help.

Matt

Does anyone have any suggestions on this? Or at a minimum can anyone share how to manually create the PostgreSQL Service to get my environment up and running?

OK, i figured it out... For anybody facing the same problem as me, here is what I had to do.

1- Install PostgreSQL
2- Run the following command from the bin of the install folder

initdb -E UTF-8 -U postgres "D:\blahblah\data"

3- Open regedit
4- Navigate to HKLM\System\CurrentControlSet\Enum\Root
5- right click the root key > permissions > and add "Administrators" with full permissions
6- Import the attached registry file
7- restart
8- Open regedit
9- Navigate to HKLM\System\CurrentControlSet\Enum\Root
10- right click the root key > permissions > and remove "Administrators" with full permissions
11- open services.msc. Find the service, and set the password for postgres account
12- right click service and choose start.
13- basked in glory, documented my learning, and then called it a day.