PDA

View Full Version : HEM/PostgreSQL won't start



buffybegood
08-12-2013, 08:19 AM
Tried to open HEM 1 today and it wouldn't, took me to the "Database Control Panel". When I clicked the "Connect" button, I got the attached error message. Help required please for someone who knows jack about anything technical.121391

Patvs
08-12-2013, 04:55 PM
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

buffybegood
08-13-2013, 08:36 AM
Unfortunately that didn't help. I'm still in therapy from my original attempts to get PostgreSQL working, is there really no alternative to reinstalling it? Do I have to uninstall what I've already got first? Will I lose my existing database?

udbrky
08-13-2013, 09:19 AM
It may help to reinstall the same version. If you install the same version in the same location, it will keep your database. Please download the same version of postgresql that you have now from Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows). Uninstall yours, and install this update.

- Please see these steps to fix postgresql connection issues:

http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+

- Please make sure that you have allowed postgres and pg_ctl in your firewall and antivirus exceptions. They are in postgres\bin. Allow port 5432 in your firewall exceptions as well.

- Please update windows fully. Please keep checking until it shows twice five minutes apart that there are no more updates.

- Please update your network adapter. Open device manager and find the model #. Search google for the model # drivers to download.

- Please run the windows repair on your winsock:

How to determine and to recover from Winsock2 corruption in Windows Server 2003, in Windows XP, and in Windows Vista (http://support.microsoft.com/kb/811259)

If you are using Mcafee, Norton, Comodo or AVG for security, they have been causing a lot of issues with postgres lately. We recommend using a different program, such as Microsoft's firewall and Microsoft Security Essential. If you do feel that you need Comodo or AVG, uninstall first, install postgres, then reinstall after it is working.

See this guide for Windows Firewall:

http://hm2faq.holdemmanager.com/questions/1052/Windows+Firewall+%7B47%7D+Defender+Problems

Download the same version you are running from Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows) - do not use 9.1 or 9.3.

Right click the setup file, click properties. Click the unblock button at the bottom.

Empty the c:\temp and/or c:\Users\Username\AppData\Local\Temp folders.

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file.

buffybegood
08-13-2013, 10:28 AM
Not a good start. Have uninstalled it, downloaded the same version from your link, but it won't install. As for all the other stuff you just listed, please remember we're not all computer experts, you might as well have typed french as "allowing xyz in firewall and anti-virus", we don't all know how to do these things.

Patvs
08-13-2013, 04:10 PM
Which Operating System, Firewall, and Anti-Virus are you using?

Please update to the latest b eta - http://www.holdemmanager.com/Downloads/HmUpdate.exe

For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.

Add exceptions to the windows firewall for holdemmanager.exe and hmhud.exe, even if the firewall is turned off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily.

Make sure your video card drivers and windows auto updates are fully updated. Run a manual Windows Update and install all updates, including all .net framework updates. And VC++ updates.

Turn off User Account Control: http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/

buffybegood
08-13-2013, 07:54 PM
Right, I've done as much as I can, but still no joy. I reinstalled using the wizard from when I originally set it up on this laptop, and thought that was going to work (it did better than the download off your link) but HEM still wouldn't connect. I then found and deleted the postmaster.pid but it still wouldn't work. Then I uninstalled that and tried your combo installer (unticking HEM of course) but that refused to install.

The UAC was already off, I've installed all the windows updates except bing, but I'm unsure of which VC++ I should try to update as when I googled it the Microsoft page I got kinda assumed you already knew what you already had, which obviously I don't. If you can specify exactly what I need to download I'll try that.

I've got Windows7, and use avast! which is supposed to be OK with HEM, isn't it?

I must admit, whenever there are issues with HEM, it is so unuser friendly to the guy in the street it's not true, it's always a real nightmare to get any issues resolved. I know you guys try very hard to help (not blaming you in the slightest, just the software and particularly PostgreSQL), but it's such hard work for those of us that know nothing about this stuff. I've already wasted hours trying to do all the stuff you suggest, and it's the same every time there's an issue.

Patvs
08-14-2013, 12:42 AM
Is your Windows 7 updated to Service Pack 1?
To install VC++:

VC++ 2005 and VC++ 2008:
Download details: Microsoft Visual C++ 2005 Redistributable Package (x86) (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=32bc1bee-a3f9-4c13-9c99-220b62a191ee&displaylang=en)

Download details: Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update (http://www.microsoft.com/downloads/en/details.aspx?familyid=766a6af7-ec73-40ff-b072-9112bab119c2&displaylang=en)

Download details: Microsoft Visual C++ 2008 Redistributable Package (x86) (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9b2da534-3e03-4391-8a4d-074b9f2bc1bf&displaylang=en)

buffybegood
08-14-2013, 07:25 AM
I've installed from the bottom link as laptop is newer than 2008. I tried your combo installer again and yet again it still won't install. I've attached the details when it failed:

Patvs
08-14-2013, 12:15 PM
Install all three VC++ links.

Install 8.4.17 from this link: Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload)


If you get an error again, install PostgreSQL 8.2: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip
Read: http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL

buffybegood
08-14-2013, 01:49 PM
I've installed all 3 now, and it still won't work with 8.4.17

Then tried the 8.2 version but when I unzip it the unzipped file is empty so no joy there either.

The only installer that seems to want to try to work is the one I originally downloaded when I first, somehow, managed to set this up, it's version 8.3 . However, now when I try to install I get to an error message that tells me that "The port number entered is already in use. Please specify a different port" . Is this something I can do? Will it help? (Port is currently set as 5432).

Patvs
08-14-2013, 03:53 PM
Use a different port number, for example 5433, or 5434.

I checked the 8.2.zip, it unzips just fine.
Try downloading it again.


121631

buffybegood
08-14-2013, 04:13 PM
I've tried 5433, it will install, but HEM still won't connect to it.

I didn't say there was nothing in the downloaded 8.2 version, there is when it's compressed, but when I unzip it, my unzipped file is empty. Undoubtedly the problem is my end, but that version is of no use to me I'm afraid.

Patvs
08-14-2013, 04:23 PM
PM sent

buffybegood
08-15-2013, 09:11 AM
Just wanted to say a big big thanks to Patvs for a valiant attempt to try to get HEM and particularly PoostgreSGL working last night via Teamviewer. It seems I had somehow managed to get a corrupted Windows Firewall that seemed to be at the root of my problems, although I had no idea it wasn't working. Good news is that we finally managed to resolve the issue today.

Many many thanks for your patience, especially as the real issue wasn't directly HEM related.

Patvs
08-15-2013, 04:06 PM
Thanks for letting us know this solved your issue.