HELP

[kraada]

The filters are stored in the database, so if there was a filter active at the time the backup was made, it would still be active after you restore. Are you able to connect to the database in PGAdmin?

[uglytuna]

Oh I understand. yeah there might of been a filter at time of backup. I can connect to the database via Admin postgres. what should I do?

[kraada]

Is it distinct from your normal PT3 database or is there just one database listed there? If there's a second database, you probably just need to reconnect your restored database into PT3 via the Database Management --> New window (click Browse, choose the database, click Ok, then Connect). If there's just one database, run the following query from PGAdmin directly (via the SQL notepad icon at the top):

SELECT max(id_hand) from holdem_hand_summary;

That will tell us how many hands are in the database - if the number is very small, something may have gone wrong with the restore.

[uglytuna]

i ran the query and it came up with 91988. I guess this is good since the number is very large.

Whats our next move?

[WhiteRider]

OK, so that looks like you have hands in the database.
Try running this query:

SELECT count(id_hand) from holdem_hand_summary;

That will count the hands instead of just checking the biggest number.

Can you confirm that you have clicked "Clear" since you restored?
Do you have more than one database shown in PGAdmin? Is PT3 showing the correct database name in the title bar?

[uglytuna]

Okay I ran the command and I got count bigint 34576

I'm press clear after the import. But when the database was backed up I believe I had a filter because I always like to see last months stats. This is the only copy of the database I have.

PT3 DB is the only database I see. In pgAdmin III when I click the PT3 DB I don't see it on the title bar.


So whats my next move?

[kraada]

That database definitely had about 35,000 hands in it then - does that sound like the right amount that would've been in the backup?

[uglytuna]

Yes that sounds right !!!

Please inform what to do next. thank you

[kraada]

I'd like to take a look at this database directly - it'll probably be easier at this point than more back and forth. Create a support ticket using this link and we'll schedule a session for you.

[uglytuna]

Ok I created the support ticket. Thank you