Page 1 of 1

can't install PostgreSQL

PostPosted: Sat Jul 14, 2012 9:07 am
by 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. :(

Re: can't install PostgreSQL

PostPosted: Sat Jul 14, 2012 11:45 am
by 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.

Re: can't install PostgreSQL

PostPosted: Sun Jul 15, 2012 7:58 am
by 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

Re: can't install PostgreSQL

PostPosted: Sun Jul 15, 2012 10:04 am
by kraada
Are you running 64 bit windows or 32 bit windows?

Re: can't install PostgreSQL

PostPosted: Sun Jul 15, 2012 10:46 am
by phatus
Running 64 bit. I made sure the Service Pack was for 64 bit.

Re: can't install PostgreSQL

PostPosted: Sun Jul 15, 2012 11:40 am
by kraada
Try installing PostgreSQL using this installer and it may work better for you.

Re: can't install PostgreSQL

PostPosted: Mon Jul 16, 2012 11:15 am
by phatus
Part way through the setup process it has asked me for a password for the database superuser (postgres) and service account (postgres)?

Re: can't install PostgreSQL

PostPosted: Mon Jul 16, 2012 11:44 am
by 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

Re: can't install PostgreSQL

PostPosted: Mon Jul 16, 2012 2:51 pm
by phatus
Thanks very much for the help it's working now. Hooray! :D

highfalutin