Videos / Other Resources

No attachments were found.

Large Log Files

Overview:

Log Files are taking up GB of space on the Hard Drive. Is this preventable?

 

 

 


Solution: 

Yes, PostgreSQL log files can become very large.  Follow the steps below to eliminate the log files altogether:

 

Note: This is for Advanced PC Users only!!!

 

 

1.  First, go to c:\Program Files\PostgreSQL\8.3\data

(For PostgreSQL 8.2 it will be 8.2>data)

2.  Open the pg_log folder. If there are logs in it, delete all of them. Only the logs, not the whole pg_log folder. Close that folder.
Now, edit the postgresql.conf folder. View it here.

 log-files-01.jpg

 

3.  Move this file to the desktop if it can not be saved.  (This is for Vista and Windows 7 users with UAC on)

4.  Open windows notepad.

5.  Click on the postgresql.conf folder and drag and drop it into the notepad window. Now the files can be read and edited.


log-files-02.jpg


6.  Next, scroll down to: logging_collector = on
(If using 8.2 it may read: redirect_stderr = on)

7.  Change this to off. (logging_collector = off) like this.  

 log-files-03.jpg




Also change #log_min_messages = warning to log_min_messages = panic as shown below:

2016-07-01_14-55-27.png

8.  Now save the change in the notepad like this.


log-files-04.jpg

9.  Copy this file back to the PostgreSQL folder.  C:\Program Files\PostgreSQL\8.3\data

10.  Close the notepad window and close the PostgreSQL folder. Restart the computer for the changes to take effect.

Next time Holdem Manager is used to play, check the pg_log folder. When done playing, it should still be empty.

 

 

 

 

 

| More

Related Articles


User Opinions (2 votes)

50% thumbs up 50% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Continue