PDA

View Full Version : where's my database?



babel92
07-02-2011, 12:23 PM
Hello,

I have huge problem. When I using Holdem Manager my computer turned off and when I turn it on and open HM I saw error:

"The following error occurred when trying to open the database: FATAL: 3D000: database "Profile1 *** DEFAULT DATABASE ***" does not exist."

I have 3mln hands in my database and it occupies 40GB hard drive, but neither HM nor pgAdmin III don't see it.

What I can do to recover my database?

Greetings
babel92

Patvs
07-02-2011, 12:28 PM
Run dbcontrolpanel.exe (in the HoldemManager folder) --> Connect--> and try to set the database as default again--> start HoldemManager

If you get a similar error again, create a new database and reimport your hands.

babel92
07-02-2011, 12:32 PM
The problem is that HM doesn't see my database!
I know I can re-import my database, but there are 3mln hands - it tooks ages! There is no other way?
What I should do with "postgreSQL" folder in Program Files -> it occupes 40GB and now isn't necessary...

Patvs
07-02-2011, 12:35 PM
Don't delete the folder just yet.
-1 delete the files inside the PostgreSQL/8.x/data/pg_log folder
-2 reinstall PostgreSQL with the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

Which version were you using 8.3.x, or 8.4.x?