PDA

View Full Version : Get the 127.0.0.1 error, sticky doesn't help



Sugar Nut
03-13-2009, 07:37 PM
I think I fucked up my postgresql. I had version 8.0 running and a buddy told me that this version is old and there's a way better one.

So I backed up my HEM database using the HEM faq page and downloaded version 8.3 of postgresql.

I thought it would just update my 8.0 but instead it just installed itself to an 8.3 folder. now i had two folders in my postgresql folder: "8.0" and "8.3"

I then uninstalled version 8.0 and here we go.....

I guess I really messed this one up, right?

How am I gonna tell HEM that there is a "new" postgresql now???

Thanks in advance,

Sugar Nut

morny
03-14-2009, 07:59 AM
How did you backup the original database, what FAQ did you use?

Sugar Nut
03-14-2009, 08:31 AM
I backed it up with PD Admin as dedscribed in this FAQ:

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12

morny
03-14-2009, 08:35 AM
Ok and did you follow the instructions for restoring the database in that FAQ?

Sugar Nut
03-14-2009, 09:03 AM
I tried, but i'm not able to.

Here's what happens:

I start HEM and get the 127 thingy

http://img3.imageshack.us/img3/2386/127m.jpg (http://img3.imageshack.us/my.php?image=127m.jpg)

then this screen pops up:

http://img3.imageshack.us/img3/8301/connect.jpg (http://img3.imageshack.us/my.php?image=connect.jpg)

When I try to connect, the following dialogue tells me that a connection could not be made:

http://img22.imageshack.us/img22/6100/attemptv.jpg (http://img22.imageshack.us/my.php?image=attemptv.jpg)

After I klick "yes":

http://img22.imageshack.us/img22/852/sorryk.jpg (http://img22.imageshack.us/my.php?image=sorryk.jpg)

And then:

http://img12.imageshack.us/img12/8029/startedh.jpg (http://img12.imageshack.us/my.php?image=startedh.jpg)

Rinse, repeat.

So I can't HEM even get to start so I also can't create a new DB to restore the old one.

It seems my old DB was not deleted even after I removed postgresql 8.0

The "base" folder was still there at least and its size indicated that there is some substantuial data in it.

I have just run a system restore to the point BEFORE I removed postgresql 8.0

Now it's there again, but still HEM won't start.

Sugar Nut
03-15-2009, 10:55 AM
bump

adjaca
03-15-2009, 01:27 PM
Hi,

I've tried getting hem to work for the past 3 days and i'm completely fed up with all this. I'm no computer wizz and I really just want to play poker. With Hem. I have tried all these things and nothing seems to help, it just doesn't connect to HEM. I also really don't want to lose my db.

Can anyone please tell me what's going on, is there gonna be an easy fix or whatsoever?

Help me out, i miss poker.

Thanks

morny
03-15-2009, 01:40 PM
bump

In PGAdmin if you right click the databases folder you can select create new database then press ok and restore to that database

bandin
03-15-2009, 01:45 PM
for what its worth, I hadnt played in about 5 days, then when I did play I got this exact same error to a tee. I hadnt touched any of the databases or anything like that, so as far as i know this error is independent of that, unless my postgre updated automatically.

help ASAP is much appreciated.

PCP Poker
03-15-2009, 01:47 PM
Most likely this is being caused by the fact that 95% of the time, databases of different PostgreSQL version numbers are incompatible with each other. Sometimes, you are able to trick PostgreSQL into working with a database that it normally wouldn't. Try my suggestions here (http://holdemmanager.net/forum/showthread.php?t=8261) and if that doesn't work, your most likely not going to get it working and will probably have to reimport.

morny
03-15-2009, 01:48 PM
Follow this thread http://holdemmanager.net/forum/showthread.php?t=8261

PCP Poker
03-15-2009, 01:51 PM
And seriously, you guys need to take some of this into your own hands. There are hundreds of other posts about the same issue. Try reading a few, there are many ideas you could be trying instead of sitting around waiting for someone to fix it for you.

Try this post (http://holdemmanager.net/forum/showthread.php?t=8182), this post (http://holdemmanager.net/forum/showthread.php?t=8046), this one (http://holdemmanager.net/forum/showthread.php?t=5561), or this one (http://holdemmanager.net/forum/showthread.php?t=8261).

adjaca
03-15-2009, 01:56 PM
After trying all the posts several times.. I just rebooted and it works!! whoohoo i'm a happy camper.


Thanks

Sugar Nut
03-15-2009, 05:30 PM
And seriously, you guys need to take some of this into your own hands. There are hundreds of other posts about the same issue. Try reading a few, there are many ideas you could be trying instead of sitting around waiting for someone to fix it for you.

Try this post (http://holdemmanager.net/forum/showthread.php?t=8182), this post (http://holdemmanager.net/forum/showthread.php?t=8046), this one (http://holdemmanager.net/forum/showthread.php?t=5561), or this one (http://holdemmanager.net/forum/showthread.php?t=8261).

Thanks, but I have tried this post, this post, this one, and this one. If you read my OP cloesely you will figure that my problem is quite differently to the problems of other users.

It's just a coincidence that mine happened to happen at the same time.

I solved it on my own now. I just removed all postgresql and then re-installed version 8.0 which i was lucky enough to find on my PC since it doesn't seem to be downloadable anymore (at least i didn't find it anywhere)

Now I just need to find out how to upgrade my postgresql without fucking up everything again...

PCP Poker
03-15-2009, 06:33 PM
I understand your error wasn't exactly the same, but I have encountered every one of those error messages in the past week and the method i suggested worked for me. PostgreSQL is a finnicky bitch, and what works for 99% of people sometimes will never work for the other 1%. Glad to hear you got it working anyways.

FWIW, you can download most prior versions of PostgreSQL at http://www.postgresql.org/ftp/binary/ if you need access to any of them in the future.
Upgrading from 8.0 to 8.3 isn't as simple as it should be. A straight upgrade very rarely works. PostgreSQL isn't very user friendly when i comes to what should be simple tasks. Recently, I was able to upgrade a server by using something similar to the method in my sticky post. However, there is the possibility you could lose your db in the process, so whatever you do, make sure you backup your database ahead of time. Postgre likes to throw random and unexpected errors at you when you can least afford it. There are some good guides available online that I have found before, but the documentation on the postgres site itself sucks.
There is also a 3rd party distibution of postgres called Postgres Plus (http://www.enterprisedb.com/products/postgres_plus.do) that is a bit more user friendly. I have had success with it in the past upgrading some meteorlogical databases from version 7.4 up to 8.2.

Sugar Nut
03-16-2009, 02:22 AM
Thanks man,

I didn't want to sound rude. These days just were kinda nerve wrecking, literally sitting in front of this thing for ages trying to make it work.

That binary site you mention I had found aswell. I was just not able to download anything from it. Well maybe I could have but I didn't know what. klick on one of the 8.x versions and pretend you don't know shit about that stuff like me or any other random guy who just wants to play poker using holdem manager:

You klick on 8.x and get a "linux" subdirectory (wtf), even if you klick on that, oh no, not a download of a linux version 8.x pops up. No, you'll get 2 more subdirectories. And if you think you're done here you couldn't be more mistaken. Unless you know what friggin "fedora" and "redhead" (or redhat? dont remember) mean, you're standing before "bohemian villages" as a saying in german goes meaning "to be clueless about something"

I was rather clueless so i fired up my windows search and just looked for postgresql-8.0.3.zip on my computer and was lucky enough to find it.

I'm keeping this version like a treasure now until I'm able to upgrade postgresql. If anyone needs it shoot me a PM (use my 2p2 account as I don't check this one too often)