PDA

View Full Version : missing database?



Dr1Gonzo
02-15-2010, 06:41 AM
Slightly bizarre but I could not start my 8.3 postgres service this morning.
So, I decided to install 8.4 instead (which installs to a new folder).
Now, I cannot find my old HEM database in 8.3 even in pgAdmin III.
ANy ideas?

netsrak
02-15-2010, 08:37 AM
You killed your 8.3 service with the new installation.
To get it back you need to uninstall 8.4, reinstall 8.3 with the existing data folder:
http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database

Dr1Gonzo
02-15-2010, 08:49 AM
You killed your 8.3 service with the new installation.
To get it back you need to uninstall 8.4, reinstall 8.3 with the existing data folder:
FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)

But it installs 8.4 to a new folder, so why would it overwrite the old data?
In the install instructions, it says it keeps old date intact.

Dr1Gonzo
02-15-2010, 11:10 AM
Even after reinstall the postgres service will not start.
I tried it through the admin panel and also through the Windows services menu, it just errors out.

morny
02-15-2010, 02:13 PM
Hi,

PostgreSQL never deletes the data folder, the only way to delete it is manually, its disconnected from 8.3 but it wouldnt be deleted by postgreSQL, most likely its in a different location than where you expect, possibly another driver or something like that.

Try searching your whole computer for 8.3 or something similar like the data folder

What error do you get when you try to reconnect, and what version of postgreSQL have you installed now, i presume its 8.4 and are you saying you cant reconnect to the 8.4 data directory with it? Assuming thats a new database then maybe delete 8.4 and reinstall it fresh, other things you can try if you havent already:

This is usually a firewall or windows update issue.

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 - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems) - Windows Firewall / Defender Problems

Please try following these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ ) Can't Connect / Failed to Start PostgreSQL
2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinst all) PostgreSQL Preserving Old Database
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (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

Dr1Gonzo
02-15-2010, 04:27 PM
I have managed to get it working again by using the combo installer but it has installed 8.4.
Can I just use the pgadmin tool to copy the database over from 8.3?
Will HEM recognise the structure in the tables - is there anything massively different?

Edit: ...so all to old data is gone now.
Is this a acse of just re-importing the backed up hands?

fozzy71
02-15-2010, 06:40 PM
I have managed to get it working again by using the combo installer but it has installed 8.4.
Can I just use the pgadmin tool to copy the database over from 8.3?
Will HEM recognise the structure in the tables - is there anything massively different?

You would need to find your \8.3\data folder and reinstall PostgreSQL 8.3 to make it work again.


Edit: ...so all to old data is gone now.
Is this a acse of just re-importing the backed up hands?

Yes, you should be able to import your archived/original hands and rebuild the DB. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

FAQ - Hold'em Manager Poker Tracking Software :: Warning: You have XXX Hand History Files in your Auto Import Folders (http://faq.holdemmanager.com/questions/119/Warning:+You+have+XXX+Hand+History+Files+in+your+A uto+Import+Folders)

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).

Dr1Gonzo
02-15-2010, 07:20 PM
You would need to find your \8.3\data folder and reinstall PostgreSQL 8.3 to make it work again.



Yes, you should be able to import your archived/original hands and rebuild the DB. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

FAQ - Hold'em Manager Poker Tracking Software :: Warning: You have XXX Hand History Files in your Auto Import Folders (http://faq.holdemmanager.com/questions/119/Warning:+You+have+XXX+Hand+History+Files+in+your+A uto+Import+Folders)

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).

I used pgpadmin to get the 8.3 server but it doesn't have any databases anymore?

So, can I find the HMArchive folder and just import from that?

fozzy71
02-15-2010, 09:57 PM
I used pgpadmin to get the 8.3 server but it doesn't have any databases anymore?

The DB isn't installed, but the \Program Files (x86)\PostgreSQL\8.3\data folder should still exist on your computer, unless you manually deleted it. If that folder is there still I might be able to reconnect the original DB.


So, can I find the HMArchive folder and just import from that?

Yes