PDA

View Full Version : Importing from a PT3 archive folder, months missing



onemanorthree
03-15-2011, 12:34 PM
Hi,

I've just recently purchased HEM and am having a little trouble importing my existing hands.

I used to use PT3 but decided to move to HEM. I pointed the import folder to the old PT3 archive folder for it to import the existing hands. The import has been running for over 30 hours now (just finished) , has taking up
all the space on me hard drive and has only picked up 1/3rd of my hands.

Should I uninstall and re-install and re-point the import folder? I only have 137,000 hands to import so it's not like it should be taking this long. Of can I just delete the database and start importing again? If so how do I deleted the database?

Also, how do I know which version of PSQL my HEM is using? I have 8.3 and 8.4 installed. PT3 uses 8.3.

Thanks

Patvs
03-15-2011, 10:50 PM
What's the main site you played those 137,000 hands on?

To delete a database: http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

When you connect to the database in pgadminIII, which SQL is using which port? Do you have SQL 8.3 on port 5432, and SQL 8.4 on port 5433??
Or are they both on port 5432 according to pgadminIII?

If SQL 8.4 is on 5433.
In HoldemManager's Database Management (can be run as dbcontrolpanel.exe, even when HoldemManager is not) make sure you connect to port 5433 when you create a new database.

If both are on port 5432. Uninstall SQL 8.4.
Install SQL 9.0.3 to port 5433 with the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) and connect to that for HoldemManager instead.

onemanorthree
03-15-2011, 10:58 PM
I managed to delete the databases in the Admin console. Then start HEM again, create a new DB and import the hands again. This worked fine and no HEM has imported all hands and is fully functional.

Is there any real benefit to upgrading to version 9?
Would this break my current setup?

Patvs
03-15-2011, 11:10 PM
Do you have SQL 8.3 on port 5432, and SQL 8.4 on port 5433??

If you already have SQL 8.4 on a separate port, there is absolute no advantage in installing SQL 9.0 instead.

In fact some features in HoldemManager like the "backup and restore utility" and "optimization tool", will only work with SQL 8.4

onemanorthree
03-16-2011, 12:40 AM
They are both running on the same port. 5432

netsrak
03-16-2011, 04:42 AM
It is not possible to run 2 postgresql services on one port.

This will cause problems and only one of them will work correctly. As Pat posted you should uninstall the other one.

As long as your postgresql is running without problems you should not install any updates.

onemanorthree
03-16-2011, 06:20 AM
Can I just change the port for version 8.4 in the admin panel?
I logged into HEM last night, it said the PSQL server was into running.
So I tried to start the service fr 8.3, it said it was already running.
I started the service for 8.4 and it started up. Then I logged into HEM again and it worked fine! So I guess it's using version 8.4.

netsrak
03-16-2011, 10:21 AM
To change the port you need to edit the pg_hba.conf - its not an easy change.

Another solution would be a reinstallation of the same postgresql version connecting to the old data folder: http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database
and changing the port during the installation.

But both require a deeper system knowledge - please create backups before trying anything like that.

onemanorthree
03-16-2011, 10:25 AM
TBH I just reinstalled PSQL 8.3 and all seems to be working fine for now.
I'm not sure it's worth messing with at the moment if it's working alright?

Patvs
03-16-2011, 09:30 PM
Justk use SQL 8.3 for both PT3 and HM if it's working.