A proglem with Postgres ...

[GeorgeJetson]

Last night I was playing poker and my power flickered ... I rebooted my computer and as my programs were loading the power flickered again. When I finally got my computer back on HEM says "The following error occurred when trying to open the database: Failed to establish a connection to '127.0.0.1'

I have went through your FAQ, uninstalled and reinstalled PGSQL (The same version I had before) ... turned off my windows firewall, made sure everything was being allowed through my other firewall, and rebooted my computer multiple times ... nothing is working.

Please help

[netsrak]

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
http://www.holdemmanager.net/forum/showthread.php?t=8261

I would start with deleting the file postmaster.pid in the postgresql data folder (it might be hidden) and another reboot.

[GeorgeJetson]

Wow, thank you .. that solved it.

[microbob]

just bumping this thread because we have another thread going with seemingly the same issue. I deleted the postmaster.pid thing and rebooted the computer and that has solved it!! Hooray. Thanks for your help.

(I first read it to mean just to 'restart HEM' but you actually have to reboot the computer)

[brody_boy]

Hi,

I have the same problem but I didnt find the file "postmaster.pid" ( probably cause i sux with computers )

Someone can give the way to get it please ???

[jonmon101]

Hey I can only find a file with the name postmaster.opts, should I just delete this file or does it make a difference since its an .opts instead of the .pid?

[fozzy71]

Hi,

I have the same problem but I didnt find the file "postmaster.pid" ( probably cause i sux with computers )

Someone can give the way to get it please ???


Hey I can only find a file with the name postmaster.opts, should I just delete this file or does it make a difference since its an .opts instead of the .pid?

No, do not delete anything else.

Try these things:

First try a simple reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Please try following all of these FAQs, step by step:

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

Try to reinstall sql and use the existing DB \data files:


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For reinstalling SQL to the same DB, follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\8.x\data directory to it's new location.
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.


http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall a clean DB and import your archives.

If you need help with any of this just let me know.