Alizona
08-12-2009, 09:17 PM
Ok, I've read all the threads on this error. I know what I need to do, which is uninstall everything AGAIN and reload everything from scratch AGAIN and import all my archived hand histories AGAIN... yada yada yeah I've been down this road more than once already and it is VERY frustrating.
Anyhow... I'm not looking for specifics of solution... I am looking for someone to explain to me in layman's terms what HEM is doing, what this POSTGRESQL thing is doing, and then please explain to me why this program crashes on me constantly and gives me this "127.0.0.1" error occasionally.
So let's start with what I DO know... very little really. I know this POSTGRESQL program is a "database". I know a "database" is just a collection of data in a file, in organized fashion so other programs can access it and use this data.
I also understand HEM is a program that can perform calculations on the data that is contained in the POSTGRESQL database. I understand this is where my statistics come from, from HEM performing calculations on my hand history data.
Ok, here's where I get lost.
Morny always tells me that it is either (a) my virus check program, or (b) my firewall, that is the reason for these HEM crashes and errors.
Well first of all, I do not run an anti-virus program. I do have AVG freeware installed "just in case", but I do not keep it resident in memory. When these problems first started after I bought HEM, I did not even have AVG. I became worried that my HEM problems were virus-related and I downloaded and installed AVG at that point to check... came up perfectly clean. I use MSCONFIG to uncheck the "AVG" application and prevent it from loading during boot up.
Second, my firewall is the stock, basic, standard-issue Windows Vista firewall. I am told that this could also be the source of the problem.
HUH?
You mean to tell me that HEM cannot communicate with POSTGRESQL because of the Vista firewall? Rubbish.
As a matter of fact, I DID go and shut down my firewall for a short time, cold rebooted my machine, and fired up HEM. Still get the same 127.0.0.1 error. Yep, it's gotta be that firewall all right!!
Ok, time for questions:
Where does the 127.0.0.1 IP address come from? Is that POSTGRESQL's "address" if you wish to connect to the database?
Can't I just allow all traffic a free pass to 127.0.0.1 in my Vista firewall (i.e. issue this IP address an "exception" from being checked)? Is this a security risk if I do so?
What is a Windows service, and why does POSTGRESQL have to be configured as one? To run as a "server", right? How come when I open the Windows Services popup and right click on POSTGRESQL and select "START", nothing happens? What is preventing it from starting?
Why does the POSTGRESQL service on my Vista laptop work perfectly fine but on my Vista desktop it doesn't - it just stays listed as "STARTING". On my laptop it is listed as "STARTED" and HEM works fine.
Why won't my service start properly on my desktop and why can't that be fixed easily without uninstalling and reinstalling everything? What causes a service to go bad?
Background: HEM has been working fine save for the occasional crash (much less frequent these days in the beta 1.09 23a). Unfortunately my video card blew up the other night while playing Team Fortress 2. Had to replace it with a new one. When I closed everything up and rebooted my rig, HEM now gave me the 127.0.0.1 error. What would cause this? All I did was uninstall my video drivers and reinstall new ones. What does this have to do AT ALL with POSTGRESQL/HEM???????
-Al
P.S. Thx for any layman's explanation of how this HEM/POSTGRESQL interaction actually works so I can try to understand what's going on and not get so angry about it. I've never had ANY program give me this many problems. And I know you guys are always trying to be helpful, I'm not mad at the customer support here, I just get angry because the solutions just don't make any sense to me. I need to understand.
Anyhow... I'm not looking for specifics of solution... I am looking for someone to explain to me in layman's terms what HEM is doing, what this POSTGRESQL thing is doing, and then please explain to me why this program crashes on me constantly and gives me this "127.0.0.1" error occasionally.
So let's start with what I DO know... very little really. I know this POSTGRESQL program is a "database". I know a "database" is just a collection of data in a file, in organized fashion so other programs can access it and use this data.
I also understand HEM is a program that can perform calculations on the data that is contained in the POSTGRESQL database. I understand this is where my statistics come from, from HEM performing calculations on my hand history data.
Ok, here's where I get lost.
Morny always tells me that it is either (a) my virus check program, or (b) my firewall, that is the reason for these HEM crashes and errors.
Well first of all, I do not run an anti-virus program. I do have AVG freeware installed "just in case", but I do not keep it resident in memory. When these problems first started after I bought HEM, I did not even have AVG. I became worried that my HEM problems were virus-related and I downloaded and installed AVG at that point to check... came up perfectly clean. I use MSCONFIG to uncheck the "AVG" application and prevent it from loading during boot up.
Second, my firewall is the stock, basic, standard-issue Windows Vista firewall. I am told that this could also be the source of the problem.
HUH?
You mean to tell me that HEM cannot communicate with POSTGRESQL because of the Vista firewall? Rubbish.
As a matter of fact, I DID go and shut down my firewall for a short time, cold rebooted my machine, and fired up HEM. Still get the same 127.0.0.1 error. Yep, it's gotta be that firewall all right!!
Ok, time for questions:
Where does the 127.0.0.1 IP address come from? Is that POSTGRESQL's "address" if you wish to connect to the database?
Can't I just allow all traffic a free pass to 127.0.0.1 in my Vista firewall (i.e. issue this IP address an "exception" from being checked)? Is this a security risk if I do so?
What is a Windows service, and why does POSTGRESQL have to be configured as one? To run as a "server", right? How come when I open the Windows Services popup and right click on POSTGRESQL and select "START", nothing happens? What is preventing it from starting?
Why does the POSTGRESQL service on my Vista laptop work perfectly fine but on my Vista desktop it doesn't - it just stays listed as "STARTING". On my laptop it is listed as "STARTED" and HEM works fine.
Why won't my service start properly on my desktop and why can't that be fixed easily without uninstalling and reinstalling everything? What causes a service to go bad?
Background: HEM has been working fine save for the occasional crash (much less frequent these days in the beta 1.09 23a). Unfortunately my video card blew up the other night while playing Team Fortress 2. Had to replace it with a new one. When I closed everything up and rebooted my rig, HEM now gave me the 127.0.0.1 error. What would cause this? All I did was uninstall my video drivers and reinstall new ones. What does this have to do AT ALL with POSTGRESQL/HEM???????
-Al
P.S. Thx for any layman's explanation of how this HEM/POSTGRESQL interaction actually works so I can try to understand what's going on and not get so angry about it. I've never had ANY program give me this many problems. And I know you guys are always trying to be helpful, I'm not mad at the customer support here, I just get angry because the solutions just don't make any sense to me. I need to understand.