PDA

View Full Version : postgresql installation problems



ladykilla85
03-13-2009, 08:59 AM
Compaq Presario 500
1.7 ghz intel celeron
1.5g ram
Windows 7 Beta V.1


Getting this error:
http://i30.photobucket.com/albums/c342/ladykilla85/10921375518-Error.png
http://i30.photobucket.com/albums/c342/ladykilla85/10921375518-Error.png



I done a little research on google. I have added postgres as a member of the user accounts under my computer>manage>user accounts. Then clicked up the properties and added it to be a memeber. This was suggested as a fix on another forum, but sadly did not work for me. I'm kind of stuck here. I've tried all kinds of things. My UAC is off. Not sure where to go from here. I am not able to start it manually from admin tools>services as well.


Any ideas?

morny
03-13-2009, 11:11 AM
Hi, Microsoft released a patch last night that has caused some issues with
the postgresql service for some people on Vista. The following steps seem to
get around this problem:

1: Go to "C:\Windows\system32\drivers\etc" and open the "hosts" file with
notepad

It might look something like this:
**************************************************
# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

::1 localhost
************************************************** ****

2: Enter "127.0.0.1 localhost" (without the quotes) at the bottom of the
file
4: Save the file
5: Restart PostgreSQL service by clicking on Start Menu - Programs -
Postgresql - Start Service

ladykilla85
03-13-2009, 11:28 AM
Well it doesn't completely install, it rolls back. Then on the re-install it says there is another database already present so I deleted the postgres folder in program files, and tried re-installing again after modifying the hosts file.

I'm still getting the same exact error. Asking me to verify I have sufficient priveleges to start system services. Sorry I'm not too familiar with SQL databases, or maybe I could be more help.

morny
03-13-2009, 11:37 AM
Have a look at these threads http://www.mydatabasesupport.com/forums/postgresql/306862-service-failed-start-winxp.html

http://www.postgresqlforums.com/forums/viewtopic.php?f=41&t=1390&start=0

They seem to indicate its a windows problem rather than a postgreSQL problem so maybe try posting on one of the PC support forums if that dosent work

ladykilla85
03-13-2009, 12:35 PM
I had read both of those last night. Does HM work with any other SQL databases? perhaps postgres 8.0? Maybe they might install. Otherwise I'm not gonna get to use HM, and I would really like to buy it.

morny
03-13-2009, 12:51 PM
Dont think 8.0 is available anymore, there are other versions available though if you want to try them, just google download postgreSQL 8.2

ladykilla85
03-13-2009, 01:22 PM
im thinking postgresql isn going to work at all, I was thinking mySQL, is it possible?

morny
03-13-2009, 01:36 PM
No you need postgreSQL, since its a windows issue try a PC forum, someone there might know the issue, sorry i couldnt be more help but i cant think of anything else to try