SOLUTION to PostgreSQL problem caused by Microsoft Windows auto update

[Rvg72]

Hi, Microsoft released a patch last night that has caused some issues with the postgresql service for some people on Vista. The following steps seem to get around this problem:

1: Go to "C:\Windows\system32\drivers\etc" and open the "hosts" file with notepad

It might look something like this:
**************************************************
# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

::1 localhost
************************************************** ****

2: Enter "127.0.0.1 localhost" (without the quotes) at the bottom of the file
4: Save the file
5: Restart your computer

Thanks,

Roy

[PetteyTheft]

doesn't seem to work. I did exactly what was said, and same issue.

[scandilous]

doesn't seem to work. I did exactly what was said, and same issue.

+1

so when do i get my money back so i can buy pokertracker instead?!

[PetteyTheft]

i restarted computer and I think everything is fine now.

[Blitz]

i restarted computer and I think everything is fine now.

+1

[Timothy88]

Noob question, but it seems i'm not allowed to change these windows files. How can I get the rights to apply the changes given above?

[superswift]

+1
++1 ty guys:)

[scandilous]

no don´t work for me! what am I going to do now?

[Wilh3lm]

Does not work for me either! This sucks! I am bleeding money right now, got only a few days left of my 60% rakeback deal..! Please gief fix or pay me huge amounts of cash!!

[scandilous]

Does not work for me either! This sucks! I am bleeding money right now, got only a few days left of my 60% rakeback deal..! Please gief fix or pay me huge amounts of cash!!

+1 this fkn sux! can someone paste exactly how it looks in your win/system32 file?

[Gagate]

It works! it is a miracle. :D

[Rvg72]

if you still don't have it working and you have rebooted and tried to restart the service then email me your hosts file and I can make sure it looks ok. Support@holdemmanager.net

Roy

[Kerith]

Works. Thanks alot, thought I would have to redo my whole system.

[Wilh3lm]

Ok, so the problem seems to be solved for me. In the hosts file mentioned above I had three lines (except from the comments):

127.0.0.1 localhost
::1 localhost
127.0.0.1 adobe something something

I was thinking that the adobe crap couldn't possibly interfere, but in the end tried to remove EVERYTHING but the line "127.0.0.1 localhost" and then reboot.

Then my postgreSQL service wouldn't start. So I uninstalled postgreSQL, reinstalled it (v8.3), rebooted the computer and rechecked that the postgreSQL service was running and that the hosts file looked as it should and voila! Now it works.

Thanks to all that have helped!

[Blitz]

+1 this fkn sux! can someone paste exactly how it looks in your win/system32 file?

From your start menu, click on COMPUTER then C: drive then Windows then System32 then Drivers then ETC then right click on "hosts" and select open, you should be given options to open with.........select note pad, make the changes mentioned above. save, reboot computer and all should work.

This is as much as I could simplify the already simple instructions already provided. Hope that works, it seemed too for most people.

[Rvg72]

One person I've been working with for the last hour or so where nothing else worked finally got working by making the hosts file change and then completely uninstalling postgresql and renaming the program files\postgresql folder to postgresql_old and then reinstalling.

I doubt many people will need to go this far but if nothing else works then this should work for you

Roy

[jenne927]

@RVG?

Do you know why I get the other error? posted in the other thread.

[pellshek]

Originally Posted by Rvg72 View Post
1: Go to "C:\Windows\system32\drivers\etc" and open the "hosts" file with notepad
2: Delete existing text
3: Enter "127.0.0.1 localhost"
4: Save the file
5: Restart PostgreSQL service

all of it....?



# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

::1 localhost

...Replaced by just "127.0.0.1 localhost"?

Tx.

[Rvg72]

all of it....?



...Replaced by just "127.0.0.1 localhost"?

Tx.

Yes

[elb_city]

This seems to work.

Many thanks,

[pellshek]

Yes

thanks Roy

[the_shwa]

Okay i follwed the instructions exactly, i've rebooted and the i'm in the same situation.

What am i doing wrong?

Can someone post a copy of their hosts file?

[AKNL]

Ok...after the initial update the trick worked.
After the 2nd 100mb update i get this crap:
994

[scandilous]

Okay i follwed the instructions exactly, i've rebooted and the i'm in the same situation.

What am i doing wrong?

Can someone post a copy of their hosts file?

the only thing that needs to be in that hostfile is;

127.0.0.1 localhost

[AKNL]

Ok...after the initial update the trick worked.
After the 2nd 100mb update i get this crap:
994

After 2 boots it seems to be working again!

[Lenty]

Worked for me, many thanks!
(Incidentally doesn't pokertracker use postgreSQL too? In which case exactly the same problem would be occurring)

[casualties]

Does not work for me.. Using postgreSQL 8.2 though...

[casualties]

Does not work for me.. Using postgreSQL 8.2 though...

ok so i uninstalled 8.2 and updated to 8.3. Working fine now but lost all my databases. Is there any way to re'import' the data from the 8.2 folder that i renamed in program files to postgreSQL_old into the new 8.3 version?

[czar17]

works after i reboot. thanks for figuring it out!!!

[VirtuaGod]

Finally. :) :)

U should put this somewhere where it is more visible cause people are only gonna read the FAQ like me and do some crazy things before doing something as simple as this.

Didn't play poker today though. U own me a couple of bucks ;-)

[Cbass]

my "host" file seems to be different than what others have described. Would someone be kind enough to help an idiot? Here is a copy of my notepad... what should I be deleting and then what and where do I type the new line?
BIG THANKS.

# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host


::1 localhost

[VirtuaGod]

Same as mine. Just put 127.0.0.1 localhost in the line below ::1 localhost and restart the computer ;-)

[Cbass]

From your start menu, click on COMPUTER then C: drive then Windows then System32 then Drivers then ETC then right click on "hosts" and select open, you should be given options to open with.........select note pad, make the changes mentioned above. save, reboot computer and all should work.

This is as much as I could simplify the already simple instructions already provided. Hope that works, it seemed too for most people.


Thanks Virtuagod... got it going.
...and a big thanks to Blitz. Couldn't figure out how to get into"hosts" before your post. Simplification to "moron-proof" is much appreciated.

[the_shwa]

Okay i have done everything as instructed, and it makes no difference. Am i the only one who can't get it going?

What is my next step??????????

[Rulenumber 6]

It works now after redoing postgres. But all my data is gone and i am pissed. Two days worth of winnings and 6 months worth of data mining all gone? not to mention my own hand histories. WTF this is not cool

[the_shwa]

the only thing that needs to be in that hostfile is;

127.0.0.1 localhost

Yes this is my hosts file, and i have rebooted however i still can't connect to postgres

[the_shwa]

One person I've been working with for the last hour or so where nothing else worked finally got working by making the hosts file change and then completely uninstalling postgresql and renaming the program files\postgresql folder to postgresql_old and then reinstalling.

I doubt many people will need to go this far but if nothing else works then this should work for you

Roy

Okay i have done exactly this, and it made no difference at all.

Any idea what i can do or is there no hope?

[tiagoferreir]

make everything still not working...def not cool, getting a little stressed with it :\

[tiagoferreir]

did everything i saw here still not working, this is def not cool...if someone could help me i would apreciate a lot !

[themerk]

i need help also.

[themerk]

Hi, Microsoft released a patch last night that has caused some issues with the postgresql service for some people on Vista. The following steps seem to get around this problem:

1: Go to "C:\Windows\system32\drivers\etc" and open the "hosts" file with notepad

It might look something like this:
**************************************************
# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

::1 localhost
************************************************** ****

2: Enter "127.0.0.1 localhost" (without the quotes) at the bottom of the file
4: Save the file
5: Restart PostgreSQL service by clicking on Start Menu - Programs - Postgresql - Start Service

Thanks,

Roy

i don't know how to do this. help. i will be home all day if you can if you can teamviewer this for me.

[-mega-]

I deleted everything and wrote 127.0.0.1 localhost
Not working need to uninstall postgres and see if it works but how do I save my database ? I can't connect.

[-mega-]

Okey now it works. Uninstalled Postgres and installed it again and imported the hands.
Now I can sleep without nightmares :P

[bazman]

After updating the hosts file, you shouldnt need to reboot - just open a command prompt and type this:

ipconfig /flushdns

[TUKKERR]

I did change the hoost to 127.01.0 or something.
But still postgres won't start.
Yesterday I removed Postgress but I couldn't install it anymore. So now HM still doesn't work..

This is what postgress says when I want to start it.


Mistake1053: the service has not the start or steering wheel task on the right way answered.

[Wilh3lm]

127.01.0 or something.

Are you kidding? You have to do it exactly right of course. Do you think your computer is a mind reader?

[TUKKERR]

Are you kidding? You have to do it exactly right of course. Do you think your computer is a mind reader?


Lol yes i was kidding, I meant this 127.0.0.1 localhost.

[Thinky]

edit: got it working!

[vincentvdn]

i'm getting so sick of this problem i've tried everything, even did the whole FAQ process again after editing my hosts file, still cannot connect to database

why isn't this working :(

[morny]

Anyone having issues fixing this please email me morny@holdemmanager.net and well do a teamviwer session