Data Disk, Log Disk, Root Partition is Filling Up

Question

Firmware Version: 9.408-0 
 We have recently been having issues with our Data Disk, Log Disk, and Root Partition filling up very fast. Multiple emails come in every day notifying us about each of these. 
 Currently: 
 Data Disk - 91% 
 Log Disk - 91% 
 Root Partition - 91% 
 I have done some research into what could be causing these problems and have been unsuccessful in resolving it. I tried to delete old logs which had no effect. We have Automatic Log File Deletion set to delete logs after 30 days. 
 The ten biggest folders are: 
 
 The results of df -h are: 
 
 I have not yet tried /etc/init.d/postgresql92 rebuild because we are hoping to have no downtime on our system (or very minimal downtime). 
 Is there something else we can do to see where these issues are coming from and how we can correct them? 
 Thanks!

sachingurung · Accepted Answer

Hi Rachelle, 
 The quickest way to resolve this is to rebuild database using the command /etc/init.d/postgresql92 rebuild but, you have to loose the reporting data. 
 You can also try another way if that helps, go to the directory and remove the files. 
 cd /var/storage/pgsql92/data/pg_xlog 
 rm 000000010000000800000XX 
 Make sure to keep the last few files on the disk, rest can be deleted. 
 Hope that helps.