can't install PostgreSQL

[phatus]

I've just reinstalled my OS and tried to install PT back onto my system. It says i need to install SQL and for this i need to be running Service Pack 1. I tried to download this and it has told me SP1 will not run on the version of windows i'm using. I'm using Windows Vista so i don't understand why there's a problem and it says this is what it should run on when i click to download.

PT says if i do not wish to install SP1 i can install an older version of SQL but the link it gives me to download PostgreSQL is broken. Any idea what i need to do to resolve this problem? Before i reinstalled my OS PT was working fine. I don't recall having this problem when i installed it originally.

[WhiteRider]

See this web page (Microsoft) for how to get the latest service pack for Windows Vista.

I wouldn't recommend getting an older version of PostgreSQL - both the Windows service pack and newer versions of PostgreSQL have many improvements and fixes.

[phatus]

Okay i didn't realise it's Windows 7 that i installed and not Windows Vista. I've now installed Service Pack 1. I now have a new problem. When i tried to install PostgreSQL it came up with the following message part way through the install:

Failed to run initdb: 1!
Please see the logfile in 'c:\Program Files(x86)\PostgreSQL\8.3\initdb.log'.

The initdb.log file contained this message:

The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail.

I used the command-line and this is what it output:

http://imageshack.us/photo/my-images/44 ... otlof.png/

I don't have a clue what this command-line is trying to tell me. Any ideas what the problem is and how to resolve it?

Thanks

[kraada]

Are you running 64 bit windows or 32 bit windows?

[phatus]

Running 64 bit. I made sure the Service Pack was for 64 bit.

[kraada]

Try installing PostgreSQL using this installer and it may work better for you.

[phatus]

Part way through the setup process it has asked me for a password for the database superuser (postgres) and service account (postgres)?

[kraada]

If PostgreSQL hasn't been installed before whatever you put in is what it uses. If it has been installed before try the following defaults:
dbpass
postgrespass
svcPASS83

[phatus]

Thanks very much for the help it's working now. Hooray!