Part of your reporting database has crashed/become corrupted is the reason for the problem. By manually deleting the files, you will have broken some part of reporting.
Log into the shell as root (or loginuser, then SU), then you'll need to run the following commands to get everything fixed, with each line being run separately.
/etc/init.d/postgresql stop
rm -fr /var/log/reporting/pgsql
/etc/init.d/postgresql start
mkdir /var/log/reporting/pgsql
chown postgres[:P]ostgres /var/log/reporting/pgsql
/var/storage/pgsql/init/reporting_db_init.sh -v
[BAlfson]In a post on 2012-05-09, Scott informed us:
It's even easier now. Just a single command:
/etc/init.d/postgresql rebuild
[BAlfson 2016-08-24] Several years ago, the command became
/etc/init.d/postgresql92 rebuild
I am currently having same issue. However, I don't seem to have proper permissions as roob to rebuild or access some locations. Please advise.
I have not yet needed to do this on a unit with 9.405, so I don't know if the behavior has changed. You should be running the command as root. I've not ever been asked for a password when doing that - and I've never tried when not.
Cheers - Bob
Thanks, Bob. Running 9.405 I am seeing the logs grow. I was not able to see the exact log as you have asked others. I believe the changes to Webserver Protect were the issue. However, a clearing of logs and reboot cleared up the issue and disk consumption is back down to 5%.
Thanks, Bob. Running 9.405 I am seeing the logs grow. I was not able to see the exact log as you have asked others. I believe the changes to Webserver Protect were the issue. However, a clearing of logs and reboot cleared up the issue and disk consumption is back down to 5%.
Hi AZ,
Do you mean you did manually remove the files at /var/storage/pgsql92/data/pg_xlogs? from what I hear it is not advisable to remove these files manually!!
we are face the same issue.
Thanks
AreshAreshi,
NO! I did not manually remove these files. It is my understanding that removing files would cause more problems. I used the SSH command to rebuild, and then rebooted and since log files have not been a issue. I followed a suggestion by BAlfson to look into the largest of log files and found that the WebServer Protection log seemed to be it (guess).
Again, no I did NOT delete or remove files. I changed the length of time in which log files were retained, which did not clean up after the 24 hour period. Then I SSH'd and looked into the log files, checking which were largest and looking at each log to see if any specific errors. I did not see anything that specifically read ERROR, so I sent the rebuild command to /etc/init.d/postgresgl92 rebuild and then restarted hours later and the logs cleared. Its been about a week and not seeing any further issue. We're at 9% and holding.
Hope this helps!