Page 1 of 1

restored DB, hands listed as 3 hours earlier

PostPosted: Wed Mar 12, 2008 12:29 am
by themightyjim2k
So I just got a new latptop and installed PT. I restored my backed up DB from my desktop so that I would have stats on my opponents on my laptop. In the process I noticed a few weird changes in my numbers from my desktop to my laptop. A little further study showed that my laptop (restored DB) is listing my sessions as 3 hours earlier than they actually occurred. So things that happened 12:01 AM on March 1st are actually being listed as 9:01 PM on Feb 29th. And this seems fairly consistent for all of the sessions.

Any way I can fix this? Obviously I can just set the preferences for 3 hours difference, and I get the same numbers on both PCs. But it would be much easier to make sure I am getting all of my hands transferred back and forth if I could more easily compare databases without having to worry about that little glitch.

Re: restored DB, hands listed as 3 hours earlier

PostPosted: Wed Mar 12, 2008 9:27 am
by ptrack pat
This is a PostgreSQL database you restored?? What version of PostgreSQL did you put on the new computer? Was it 8.2? PT would not have changed any dates in the database so this is some PostgreSQL issue that I'm not aware of.

Re: restored DB, hands listed as 3 hours earlier

PostPosted: Wed Mar 12, 2008 11:22 am
by themightyjim2k
[quote="ptrack pat"gez]This is a PostgreSQL database you restored?? What version of PostgreSQL did you put on the new computer? Was it 8.2? PT would not have changed any dates in the database so this is some PostgreSQL issue that I'm not aware of.[/quotegez]

pretty sure it was 8.2. I followed the links from the old PTH forum, and several of those threads mentioned that we should use 8.2 instead of 8.3 because of some compatibility issues.

I'll recheck this afternoon, and if I notice something different I'll post it.

thanks,

jim