PDA

View Full Version : Postgress - Windows 7 - About ready to smash something



pcallinallin
10-27-2010, 06:27 PM
I don't know if there was a problem with the windows update this week, but I see a number of threads addressing similar issues.

http://forums.holdemmanager.com/manager-bugs/38164-failed-connect-database-tried-everything.html

This is just one. ^^^

I have been following FAQs and trying to fix this all day and Im not totally pissed off and don't even know if Im better or worse off than when I started.

I have uninstalled HEM and PGAdmin / Postgres and now have both running BUT it seems that I have HEM setup with a new postgres and not the Original one named postgres in pgadmin.

I don't want a 14 hour import saga! How can I associate HEM with the "postgres" DB and get rid of the new "HEMDB" that was created in my reinstalls?

Someone please help me, It seems like it should be easy, but im about ready to smash things.

Thanks

fozzy71
10-27-2010, 06:54 PM
Your old DB may not be salvageable, but you can give it a try. Databases can become corrupt for many reasons, and you often have no idea why they were damaged. If you have all the original hands in your \HMArchive it is often just as easy to import the hands before bed, and rebuild the database.


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 > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)

sql 8.3 - http://www.holdemmanager.com/downloads/postgresql.zip

sql 8.4 - http://www.holdemmanager.com/downloads/postgresql_8.4.1.1.exe

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.