PT on two different drives

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

PT on two different drives

Postby C2Knuckles » Tue Nov 27, 2012 11:39 am

I'm just wondering where do I go from here? Here is what I did...

I had my database on my D drive since it was too large for the C. Everything was working fine. I decided to upgrade Windows and I did a fresh install. I wiped the C drive clean and the D drive (with the database on it) was untouched.
So now I reinstalled everything. The new install is on the C drive. How do I get the program to use the database that is still on the D drive and get things like I use to have it?
I looked at the FAQ: Database / PostgreSQL thread and I'm not sure if any of those apply to me, or maybe it's right there and I'm not thinking straight without my morning coffee. I just don't want to mess this up and lose my database.
C2Knuckles
 
Posts: 85
Joined: Sat May 17, 2008 6:11 pm

Re: PT on two different drives

Postby kraada » Tue Nov 27, 2012 12:30 pm

The easiest way to do this is to just uninstall PostgreSQL and reinstall it on the D drive in the same location it was in before. It will pick up the data directory that's there and use it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT on two different drives

Postby C2Knuckles » Thu Nov 29, 2012 2:07 pm

kraada wrote:The easiest way to do this is to just uninstall PostgreSQL and reinstall it on the D drive in the same location it was in before. It will pick up the data directory that's there and use it.


Thanks! Looks like everything is back to the way it was.

But one more thing, looks like I have the same duplicates or triplicates of the same database. My hard drive is way more full than it should be. Under database management I try to delete the two databases that are not active I get the error message: Unable to execute query: DROP DATABASE "PT3 DB" ;; Reason: Fatal Error (ERROR: database "PT3 DB" does not exist )
C2Knuckles
 
Posts: 85
Joined: Sat May 17, 2008 6:11 pm

Re: PT on two different drives

Postby kraada » Thu Nov 29, 2012 4:48 pm

That error means that database does not exist under that name so there is nothing to delete from PostgreSQL. You can remove it safely from the PT Configuration using the Remove button.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT on two different drives

Postby C2Knuckles » Thu Nov 29, 2012 5:19 pm

That worked, but I don't see how my database can be that big, I don't think it was before.
My PostgreSQL folder is 134GB. There is 72.5GB in PostgreSQL/8.3/data folder and 61.4 in the Postgres/data folder. Does this sound right?
C2Knuckles
 
Posts: 85
Joined: Sat May 17, 2008 6:11 pm

Re: PT on two different drives

Postby kraada » Thu Nov 29, 2012 6:58 pm

That sounds like you have two installations one in the 8.3 folder and one in the PostgreSQL folder directly. If that's the case, the one you're not using can be deleted, but we'd need to figure out which one that is. Are files in both data folders being updated regularly as you are importing?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT on two different drives

Postby C2Knuckles » Fri Nov 30, 2012 3:39 pm

kraada wrote:That sounds like you have two installations one in the 8.3 folder and one in the PostgreSQL folder directly. If that's the case, the one you're not using can be deleted, but we'd need to figure out which one that is. Are files in both data folders being updated regularly as you are importing?


I'll take a look soon. I'm running the Housekeeping and it's going on 21 hours now. :? Waiting for that to finish up.
C2Knuckles
 
Posts: 85
Joined: Sat May 17, 2008 6:11 pm

Re: PT on two different drives

Postby C2Knuckles » Sat Dec 01, 2012 11:40 am

After going on for 38 hours of housekeeping I gave up and closed PT3 in the task manager. Don't know why that takes an eternity but that's another story.

After doing a manual import it looks like PostgreSQL/data gets updated after an import and PostgreSQL/8.3/data does not.
Do I just delete the 8.3 folder? And the 8.3/data folder in there is 12GB larger than the other one.
Or should I just export as many hand histories as I can, wipe PT3 and PostgreSQL completely from this computer and start over? I'm close to doing just that because nothing is working well. :x
C2Knuckles
 
Posts: 85
Joined: Sat May 17, 2008 6:11 pm

Re: PT on two different drives

Postby WhiteRider » Sat Dec 01, 2012 12:40 pm

If you're sure that you don't have any databases in the "8.3" PostgreSQL install then you can delete it.
Are you missing any data?
If you're sure there aren't any databases you need in there then you can delete it, although that is where the normal PostgreSQL installation would be.

If you have all of your hand history files (or you can generate them all with exports) then a clean installation of PostgreSQL would probably be a good idea.
(You wouldn't need to remove PT3 to do that.)

If you want to remove PostgreSQL and start over, follow the uninstall directions in this tutorial.
Since you're doing a manual PostgreSQL install in this case I'd suggest installing PostgreSQL 9.0 - that is the version we currently recommend and will give you a little performance improvement, especially if you have 64-bit Windows. (Follow the installation part of this tutorial.)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PT on two different drives

Postby C2Knuckles » Sat Dec 01, 2012 1:02 pm

Yeah, I'm just going to start over. Thanks for your help.
C2Knuckles
 
Posts: 85
Joined: Sat May 17, 2008 6:11 pm


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests