Lost My Whole Hand Database and Can't Connect To Postgres Now

[Xavier]

I somehow managed to open connect to Postgres and open HEM last night but I had lost my entire hand history from reinstalling HEM, and couldn't find how to get it back.

Now this morning i can't even connect to Postgres again.
How do I now connect to Postgres and get my hand history back.
It won't connect with the default settings.

[Xavier]

Also I tried to reimport the whole database again last night from Pokerstars but it still wouldn't come up in HEM, but it has taken my Hand Histories out of the Pokerstars folder so now I don't have a back up of them.

As far as I know the database is in in the PostgreSQL so would reinstalling PostgreSQL lose my database?

I think I may have somehow anadvertently changed the username/password to connect to PostgreSQL, so I can't connect to it now.

[Xavier]

Found I had all my hand histories somewhere else so tried deinstalling and reinstalling PostgresSQL.

I still can't connect to it :(

[fozzy71]

Which Operating System, Firewall, and Anti-Virus are you using?

This is usually a firewall or windows update issue. Please follow the stpes below and they should help you to reconnect or reinstall sql.

Make sure windows is fully updated and change your Windows Control Panel > Regional Settings Format to English (USA).

The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services > secondary logon > right-click > start AND right-click > properties > startup type: automatic.

http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+

First try to reboot.

If no help, try this:

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

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

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems

Please try following these FAQs, step by step:

1) http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+
2) reinstall the same version of postgresql, using the same \data folder - http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database
3) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

[Xavier]

I have Norton Antivirus Firewall on my computer.

[Xavier]

I can connect to Postgres SQL now, and open HEM OK now but I have lost all my hands which I uploaded when I had the trial version.

How do I get the hands which I imported before to come up.

[Xavier]

I figured out how to get my old hands to show up.