PT3 performance tuning 2 HDDs

General discussion of PokerTracker 3.

Moderator: Moderators

Re: PT3 performance tuning 2 HDDs

Postby kraada » Mon Aug 24, 2009 9:11 am

No, you'd have to actually set up RAID either via a hardware RAID controller or using RAID software. This page is one of many that discusses setting up RAID via software.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT3 performance tuning 2 HDDs

Postby live2bet » Wed Aug 26, 2009 10:22 am

Thanks kraada.
I'm completely lost, just spent too much time on this performance tuning...

I just got my new HDD installed specially for PT3 data only.
Like advised, i have created "pg_data" and copied "schema.postgres.sql" on my D drive (my new HDD).
What's next?
I assume i have to move my data from my original location (C drive) to my new HDD (D drive), is so please advise on my next step or provide link please.

Need to get back to playing, tooo much time spent on this "tuning".
Please help.

Thank you.
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: PT3 performance tuning 2 HDDs

Postby kraada » Wed Aug 26, 2009 10:30 am

It sounds like you got to the start of the paragraph that begins "Now we need to allow" - I explained it all earlier in this thread, in this post.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT3 performance tuning 2 HDDs

Postby live2bet » Wed Aug 26, 2009 10:35 am

Yes, under security on pg_data folder, i have allow full access.


I'm stuck here
Image
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: PT3 performance tuning 2 HDDs

Postby kraada » Wed Aug 26, 2009 11:03 am

The file is named "schema.postgres.sql". That's my fault; I've fixed the original post. :oops:
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT3 performance tuning 2 HDDs

Postby live2bet » Wed Aug 26, 2009 11:10 am

I'll let you slide this time :)
After "schema.postgres.sql" and Enter, nothing happens, just "pt3_newdb-#...
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: PT3 performance tuning 2 HDDs

Postby kraada » Wed Aug 26, 2009 11:42 am

Type \d and hit enter, do you see a bunch of tables?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PT3 performance tuning 2 HDDs

Postby live2bet » Wed Aug 26, 2009 11:50 am

No kraada.
"No relations found"
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: PT3 performance tuning 2 HDDs

Postby live2bet » Wed Aug 26, 2009 12:21 pm

Hey kraada, got it!
Retyped " \connect pt3_newdb;", " \cd D:", " \i schema.postgres.sql" and it seems to be working now.
Thanks.

Gonna work on PokerTracker3's Database Management now, wish me luck please.
Will update.

Appreciate your patient.

:D :D :D
Image
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: PT3 performance tuning 2 HDDs

Postby live2bet » Wed Aug 26, 2009 12:36 pm

I think i got excited tooo early :( .
Are my old data on my new HDD now?
Can i, should i delete my old data on my C drive and how?
Set PT3_2009_080_26_092305 as my Active/Default database but there's no database on PT3 now.

We are very close kraada, don't give up on me :) .
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

PreviousNext

Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 43 guests

cron