Cant install PostgreSQL

[vincent]

I was able to use HM in the past but now it no longer works after I purchased the full version. I am running win 7 64x. I have tried changing my security settings and reinstalling. I have read the other threads with the same problem but none of those solutions worked (using different sql versions)
I still get "Sorry could not install PostgreSQL"
failed to establish 127.0.0.1

help please?

[Patvs]

This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely

You currently installed SQL from the combo installer (=8.4.1)?
Did you try 8.2.18 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org), that one always works.

PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.18/win32/postgresql-8.2.18-1.zip)

[vincent]

i tried to reboot, doesn't work.

tried to stop server
says "The service name is invalid"
Tried to start server
says "the service name is invalid"

tried to install, will not install fully.

[vincent]

i installed the other version of postgreSQL. now I can't connect to postgreSQL with the password i had used.

[vincent]

i tried

Fabio found the following and it worked for the first person I tried it on: doing the following steps are apparently fixing the problem so many people are having:

1: Go to "C:\Windows\system32\drivers\etc" and open the "hosts" file with notepad
2: Delete existing text
3: Enter "127.0.0.1 localhost"
4: Save the file
5: Restart PostgreSQL service

did not work either.

[vincent]

got it, thanks.

[Patvs]

To be able to enter a password again during installation delete the postgres user:

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /del' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.