Converting PT databases to postgreSQL

ChuckTs · Oct 27, 2007

(trust me, I'm just as lost as you are).

Converting your database helps speed up retrieving time and I think saves space too. Especially helpful with bigger databases. I'm trying to install it and convert my DB right now but can't even find the right installation file

Anybody have a postgresql DB that could help me out?

This is also just a reminder to the frequent players who are raking in up to the tens of thousands/100k+ hands that you'll probably need to do this soon.

rob5775 · Oct 27, 2007

Taylor, I converted mine a while ago but can't remember how. Stormswa did a instructional video on PT and he explained it. I'll search for the vid if you can't find it.

rob5775 · Oct 27, 2007

I think this is it:

https://www.cardschat.com/forum/general-poker-13/pokerace-hud-pokertracker-ftto-script-86192/

ChuckTs · Oct 27, 2007

Thanks rob; downloading it now.

Is it as complicated as it is intimidating?

skoldpadda · Oct 27, 2007

I did it following his instructions and it was a snap.

rob5775 · Oct 27, 2007

Naw, It was pretty straight forward. If you have a lot of hands, like I did, then it just takes a little while. Brian did a good job of explaining it.

ChuckTs · Oct 27, 2007

What do you guys have inputted under postgres settings>ODBC Entry to use?

This is something he didn't explain.

edit: nevermind, found it.

(and ya, this looks a lot easier than I'd thought. PT's forum and their jibber-jabber just scared me

)

Thanks again guys.

NineLions · Oct 27, 2007

Thanks from me for the link too Rob. I only got part way thru making the conversion. Instead I exported my last 2 months of hands, created a new database, imported the 2 months of hands, and changed databases.

But, I should still finishe the conversion.

Stick66 · Oct 27, 2007

Remember: Postgres WILL NOT work on FAT file systems. Most XP machines are FAT unless you convert them, which is a very technical procedure.

ChuckTs · Oct 27, 2007

FAT meaning what?

Mine is a custom pc i made myself...really not sure if it is or not :/

Stick66 · Oct 27, 2007

ChuckTs said:
FAT meaning what?

Mine is a custom pc i made myself...really not sure if it is or not :/

I forgot what FAT means, but here's how to check:

Go to "My Computer".
Right click your C: drive and select "properties".
Then read what it says for "File System:".
(I'll betcha it's FAT or FAT32.)

ChuckTs · Oct 27, 2007

NTFS

\o/

Thanks though Stick. (whew)

Stick66 · Oct 27, 2007

ChuckTs said:
NTFS

\o/

Thanks though Stick. (whew)

Excellent! Go for it!

ChuckTs · Oct 27, 2007

Just merged my 45 databases (6, j/k) into one and started converting it.

Actually just ran into an error that's complete jibberish to me; gonna forward it to PT.

ty for the help guys.

aliengenius · Oct 27, 2007

I converted mine a while ago too. One problem I have now: every time I reboot the computer I have to manually go in and stop, then re-start the postgresql process. If I don't, and try to open PT, it hangs and can not access the database

.

Stopping and starting the process again makes it fine, PT will then open.

Oh well.

skoldpadda · Oct 27, 2007

yes my XP is same as Chuck - NTFS and I had no probs with it.

ChuckTs · Oct 27, 2007

fyi I fixed whatever the error did and everything works perfectly.

Much faster now

Four Dogs · Oct 27, 2007

FAT = File Allocation Table

Converting PT databases to postgreSQL

ChuckTs

Legend

rob5775

Legend

rob5775

Legend

ChuckTs

Legend

skoldpadda

Caveman Eye Surgeon

rob5775

Legend

ChuckTs

Legend

NineLions

Advanced beginner

Stick66

Legend

ChuckTs

Legend

Stick66

Legend

ChuckTs

Legend

Stick66

Legend

ChuckTs

Legend

aliengenius

Cardschat Elite

skoldpadda

Caveman Eye Surgeon

ChuckTs

Legend

Four Dogs

Legend

About CardsChat

Our Community

Our Site