Can i know how many hands my DB contains ?+more

[mager]

Can i know how many hands my DB contains ?

Also i have another question:
I reinstall my computer so i had to manually import my hands(more then 1M i guess). During that time the electricity went down so my computer shut down. When i tried to enter PT again a i saw a message that says that fatal error occurred. I reopened the program and everything worked ok(i didn't try to play yet has i have to import my hands first). I stared importing all the hands again and it writes a lot of them a duplicates which is reasonable as i guess those are the hands that has already been imported before the crash. Anything I have to worry about or it should all be ok?

Last question I have is should i rebuild cach or reindex after importing so many hands ?

Thanks.

[kraada]

You can see how many hands are in the database on the Summary tabs for each game type.

Duplicate error messages just mean that a hand wasn't imported now because it already had been there's no damage to your database.

Importing 1M hands a cache rebuild is going to be faster than a cache update, but you shouldn't need to reindex normally at any point - that will only really be necessary if there's corruption or you're upgrading database versions.

[mager]

So the fatal error that occurred because of the crush doesn't mean there is a problem ?

After importing all of my hands i should do cluster, vacuum and analyze. Then when it complete i should do cache rebuild. Is this the right order? If i do cache rebuild there is no need for cache update?

thanks :)

[mager]

I have another off topic question:
Is there any way to change how poker tracker define positions? I saw this :
http://img253.imageshack.us/img253/4849 ... onssi1.png
and i play a bit differently. Any way i can change that ?

[kraada]

You will most likely be fine.

You can alter the lookup_positions table that is used in the database, though you'll need to rebuild the cache afterwards to get the updated definitions. At this point it requires doing everything via PostgreSQL queries - I'll gladly provide you with the queries you want if you tell me what you're trying to do though. Eventually this process will be made much more user friendly, though I don't know when that will be happening.

[mager]

For some reason it wrote it doesn't recognize the registration code and asked if want to move to trial mode(something like that), I said no and reopened the the program. It loaded regularly. I really hope it wont make problems and that i wont have to reinstall as it took forever to import the hands.

Here is what i want it to changed to:
10 players: LP LP MP MP MP EP EP EP
9 players: LP LP MP MP MP EP EP
8 players: LP LP MP MP MP EP
7 players: (its good as it is)
6 players: LP LP MP MP
5 players: LP LP MP
4 players: LP

If you can instruct me how to change it to those settings it will be great. I think those are the most accurate for FR players.

[kraada]

Click Start --> Programs --> PostgreSQL --> psql to 'postgres'. Type your postgres user password at the prompt and hit enter (the default is dbpass and you won't see any *s, just type and hit enter). At the prompt type \l and hit enter to list the databases, then \connect "Your Database Name Here" and hit enter to switch to your database (if there is a space in your database name, the quotes are required). The prompt will change to let you know you've connected successfully.

I am assuming given your progression you want LP LP for 4 players - if you want LP MP for 4 players instead, let me know and I'll give you two additional queries to run.,

Then copy and paste these queries and hit enter after each one:

UPDATE lookup_positions SET flg_lp = TRUE where position = 1;
UPDATE lookup_positions SET flg_ep = FALSE where position = 1;
UPDATE lookup_positions SET flg_mp = TRUE where position BETWEEN 2 AND 3;
UPDATE lookup_positions SET flg_ep = FALSE where position BETWEEN 2 AND 3;
UPDATE lookup_positions SET flg_mp = TRUE where cnt_players = 8 and position = 4;
UPDATE lookup_positions SET flg_ep = FALSE where cnt_players = 8 and position = 4;
UPDATE lookup_positions SET flg_mp = TRUE where cnt_players = 10 and position = 5;
UPDATE lookup_positions SET flg_ep = FALSE where cnt_players = 10 and position = 5;

[mager]

For some reason i cant type anything in the "psql to 'postgres' winow". I can only press enter and it writes wrong pass, then if i try to type any key the windows get closed.
What can be the problem? (I have no problem writing in other cmd windows).

P.S
If didn't choose any name for the DB it is should be "PokerTracker 3 Database" right ?
And yes 4 players is LP LP. 7 players is LP LP MP MP EP.

[kraada]

Follow this tutorial then and it won't ask you for any password. The default database name in PT3 is "PT3 DB" but you'll see it listed there on the left column of the output from the \l command.

Also you'll need to run a Cache Rebuild via Housekeeping once these settings are changed.

[mager]

The password issue resolved- ill try later to do the rest.
Thanks a lot man. Its not the first time you''r been VERY helpful to me :)

Oh and i have small question:
Now when iv'e set the password thing, do i need to still use password when i add PT3 database to table selection softwares(i don't use PT3 table selection feature but other software)? Or should i just use the username "postgres" and leave the password blank ?