PDA

View Full Version : While updating database - cannot connect to PostgreSQL ?!



FavoriteJackDaniels
08-10-2012, 07:35 AM
Greetings, again, unfortunately ;D

So I updated my HM2 to newest version and as it seems I am obligated to update my database. That sucks cause I have 11 million hands in it and by the average measurements in the FAQ with the fastest computer ever best case scenario will take 50 hours.

So I leave my pc on for the whole night and when I wake up the bar hasn't moved a bit, but there is an error occurred, hurray.

Image #1 (http://i680.photobucket.com/albums/vv161/gelvis1/1-1.png)

so when I pressed okay, after taking the screenshot, I received another pop-up saying it's fine, database has successfully updated and renamed. I did not take the screenshot cause on a second there I actually believed that everything is fine, what a dumbass am I, right ? ;D

So I turn on HM2 again and it asks to update. I do, and in about 10 minutes it shows the same error again [image #1], so I press OK and it reappears for 2 more times till this beauty pops up Image #2 (http://i680.photobucket.com/albums/vv161/gelvis1/3.png) and then this one Image #3 (http://i680.photobucket.com/albums/vv161/gelvis1/2.png). So, what's up with that? I am the only user on this PC.

Also, the is a post, no really related to my, but I tried the solution - "Fix for PostgreSQL cannot start error 127.0.0.1" (http://forums.holdemmanager.com/manager-general/8182-fix-postgresql-cannot-start-error-127-0-0-1-a.html), no effect.

I run the program as administrator,
by default the firewall is disabled,
Windows7, 3.25GB RAM, 1GB Graphics card and a shitty Intel Dual core processor.

By the way, while I'm at it, 11 million hands will seriously take my forever to upload, is that update really mandatory, I played fine without it. Plus I cannot let it update for several days, and then at the end pop up another error saying that this time my mother in law is the issue.

FavoriteJackDaniels
08-10-2012, 07:43 AM
Just sent the log file to hm2support@holdemmanager.com.

Patvs
08-10-2012, 03:47 PM
Ideally, create a new database, and reimport your hands.

That's basically what the database update also does.
But by doing it manually, you can import your last 2 million hands (or only import 2012).
Then import the rest in the upcoming days.

We're aware it takes 2 minutes now to load HM2 (loading hands) if you have a 11 million hands database. This issue will be fixed in the upcoming 'hybrid" build, which allows you to specify how many hands should be cached.

FavoriteJackDaniels
08-10-2012, 05:23 PM
That is not serious. It took me a whole week to import them all nonstop and create those notes.

FavoriteJackDaniels
08-10-2012, 07:34 PM
How do I make a new database. ?

Patvs
08-10-2012, 10:26 PM
Home tab--> Database