PDA

View Full Version : Postgre problem again...sigh



Shafty78
08-03-2010, 03:47 PM
Seems like I get this every few months and it frustrates me every time. For some reason I was getting that 'can't connect' message and now after trying everything in the FAQs I can't even get Postgre to download to my computer. I need some help please.

Patvs
08-03-2010, 06:04 PM
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.


Which SQL version do you have now?
Download 8.4.4. from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

Shafty78
08-03-2010, 06:11 PM
I have tried all the things you have suggested with no joy. I currently have SQl 8.4, but I think I may have deleted it. I certainly tried to uninstall but it is still sitting in Programs.

I want to download the new HM/Postgre combined file but at the end of the download it says Postgre hasn't worked.

Any suggestions?

Shafty78
08-03-2010, 06:19 PM
I just tried to download the SQL 8.4.4 version and I have no idea what the password is so I have reached an impasse.

Patvs
08-03-2010, 06:47 PM
If the HM/SQL combo installer fails on SQL--> you've have to manually install it.

The password is postgrespass
If it doesn't ACCEPT that-->

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.

Shafty78
08-03-2010, 07:23 PM
Tried all that, still not working.

netsrak
08-04-2010, 06:02 AM
Do you get any error message or what happens?

Shafty78
08-04-2010, 05:42 PM
Guys, I really need some help. Keep trying to reinstall the combo HEM/Postgre installer but no joy. It says I have a problem with the password. I have tried 'dbpass' with no luck.

Guess I've lost my DB too :(

Patvs
08-04-2010, 11:39 PM
pm sent