PDA

View Full Version : pg_log



PojkenMedTur
11-10-2008, 07:29 AM
My pg_log folder is taking up over 10gb of space on my hard drive. The base folder takes up 23.6.

What will happen if delete all files in the pg_log folder?

fabio
11-10-2008, 08:35 AM
Nothing, you can delete them

snipthetip
06-08-2009, 12:45 AM
But what about the files in the base folder? Can these be deleted without any negative effects to the manager? I once tried to delete the files in here to clear space on my hard drive, and the manager wouldn't import hands any more. If someone could help me out, I would really appreciate it. Or, if there is no way to remove those files in the base folder, let me know that as well. Thanks.

morny
06-08-2009, 10:52 AM
Only remove the hands from the pg_log folder and nowhere else otherwise youll corrupt the database and lose your hands

snipthetip
06-08-2009, 11:07 AM
Is there any way I can move the files in the base folder to an external hard drive, or are they simply stuck there as long as I have the manager?

alllysssa
06-08-2009, 11:50 AM
You could use 'NTFS junction points'. Google for that term and you'll find tons of info. Junction point is not the same as a windows shell shortcut though, so be warned. If you're not a computer savvy, better stay away from it.

Here I'll give an example how I use it at home. My HM database got quite big (around 70 gig), and was residing on my OS-drive. Add to that all the programs I have for daily use, I was bound to run out of space soon.
So I bought an extra 1TB drive, and created an junction point that's pointing to my new drive. So C:\Program Files\PostgresPlus\ points to E:\PostgresPlus\ (ofcourse I copied everything in the PostgresPlus folder to the E:\PostgresPlus\)

Remember, this is not the same as a windows shell shortcut and I wouldn't recommend this solution, but it is possible. A good site with explanations and a program that integrates in the windows shell here (http://schinagl.priv.at/nt/hardlinkshellext/hardlinkshellext.html).

snipthetip
06-08-2009, 01:00 PM
You could use 'NTFS junction points'. Google for that term and you'll find tons of info. Junction point is not the same as a windows shell shortcut though, so be warned. If you're not a computer savvy, better stay away from it.

Here I'll give an example how I use it at home. My HM database got quite big (around 70 gig), and was residing on my OS-drive. Add to that all the programs I have for daily use, I was bound to run out of space soon.
So I bought an extra 1TB drive, and created an junction point that's pointing to my new drive. So C:\Program Files\PostgresPlus\ points to E:\PostgresPlus\ (ofcourse I copied everything in the PostgresPlus folder to the E:\PostgresPlus\)

Remember, this is not the same as a windows shell shortcut and I wouldn't recommend this solution, but it is possible. A good site with explanations and a program that integrates in the windows shell here (http://schinagl.priv.at/nt/hardlinkshellext/hardlinkshellext.html).

thanks for this. im definitely not computer savvy at all, so per your suggestion, perhaps i'll stay away from it. if you, or anyone, has any other suggestions on what to do with this, i'd greatly appreciate it.

stretch00
06-08-2009, 01:49 PM
Here's a link I think you want to look at,I did this with no problems to HM/SQL what so ever.
How to make PostgreSQL stop making those big log files (http://www.holdemmanager.net/forum/showthread.php?t=8423)

link to complete thread; Top 10: HEM performance increase tips (http://www.holdemmanager.net/forum/showthread.php?t=11194)

snipthetip
06-08-2009, 03:43 PM
Here's a link I think you want to look at,I did this with no problems to HM/SQL what so ever.
How to make PostgreSQL stop making those big log files (http://www.holdemmanager.net/forum/showthread.php?t=8423)

link to complete thread; Top 10: HEM performance increase tips (http://www.holdemmanager.net/forum/showthread.php?t=11194)

stretch, thanks for this. do you know if doing the things in the first link will prevent files being made in the base folder? stopping the pc_log files from getting made is one thing, but the base folder is the true issue.

stretch00
06-08-2009, 05:22 PM
stretch, thanks for this. do you know if doing the things in the first link will prevent files being made in the base folder? stopping the pc_log files from getting made is one thing, but the base folder is the true issue.
I wish I could answer that from a more knowledgeable position but I really cant! What I do know is that all my folders in the base look like this as far as contents;
FOLDERS
#1/ 4.15mb
11511/ 4.21mb
11510/ 4.4mb
274395/ 318mb
pgsql_tmp/ 0

Don't know if that helps!

snipthetip
06-08-2009, 10:59 PM
I wish I could answer that from a more knowledgeable position but I really cant! What I do know is that all my folders in the base look like this as far as contents;
FOLDERS
#1/ 4.15mb
11511/ 4.21mb
11510/ 4.4mb
274395/ 318mb
pgsql_tmp/ 0

Don't know if that helps!

Have you been noticing those numbers increasing over time as you import more hands into your DB? If they are, then that script only gets rid of the pc_log files, if they have stayed the same for a while, then that script gets rid of the base folder files as well, which is the key issue. Let me know what you think.