Can`t connect to PostgreSQL Database?

[tjessop]

My HM2 wont load up, it brings up a page that says it cant connect to postgreSQL? it wont let me reset password, and I try to retry connection but it get an error message saying; cant connect to postgresql (wrong sever, port or firewall enabled) but I don't have any active fire walls and have the latest version of windows etc etc. any help thanks!

[udbrky]

- Please see these steps to fix postgresql connection issues:

http://hm2faq.holdemmanager.com/questions/1001/Can+not+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

- 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. See this guide for windows firewall:

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

- 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.

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. Uninstall yours.

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.

Install in the same location yours was installed in.

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

[tjessop]

- Please see these steps to fix postgresql connection issues:

http://hm2faq.holdemmanager.com/questions/1001/Can+not+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

- 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. See this guide for windows firewall:

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

- 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.

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. Uninstall yours.

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.

Install in the same location yours was installed in.

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

I tried all these steps already, and its pretty complicated. again I have no fire wall or anti virus as they are all deleted, my windows is currently up to date. I don't understand this winsock thing asa I cant find it on my computer. I also tried downloading the current postgresql from the link and again no change. im not very good with computers and it seems like there are quite the hoops to go through for this...anyway I can do a team viewer meeting like I have in the past?

[tjessop]

I think the original postgreSQL got deleted.. I guess I just need to know which one I was running before?

[tjessop]

one other thing... could I try a system restore to yesterdays date? as it was working fine yesterday? or does that run a risk of deleted or wrecking things?

[tjessop]

its all good I think I figured it out

[udbrky]

Thank you for letting us know this is resolved.

Good luck at the tables,

Please let us know if we can help with anything else.

[tjessop]

Thank you for letting us know this is resolved.

Good luck at the tables,

Please let us know if we can help with anything else.

you bet! thanks you