postgresql – Autovacuum未在Openshift Online Postgres盒式磁
我的Openshift在线墨盒上有Postgres 9.2.使用Pgadmin3,我已经启用(通过勾选方框)
postgresql.conf的autovuum设置.但是,autovacuum似乎没有运行.
这是我有的: > ps -ef | grep -i vacuum 我错过了什么? 编辑 当问题pg_ctl重启-m fast我得到了 LOG: could not bind socket for statistics collector: Permission denied LOG: trying another address for the statistics collector LOG: could not bind socket for statistics collector: Permission denied LOG: trying another address for the statistics collector LOG: could not bind socket for statistics collector: Cannot assign requested address LOG: trying another address for the statistics collector LOG: could not bind socket for statistics collector: Cannot assign requested address LOG: disabling statistics collector for lack of working socket WARNING: autovacuum not started because of misconfiguration HINT: Enable the "track_counts" option. LOG: database system was shut down at 2014-04-22 09:58:19 GMT LOG: database system is ready to accept connections 虽然在postgresql.conf中已将track_counts设置为on 很抱歉这么愚蠢,但任何帮助或指示非常感谢.
我遇到了类似的问题,并在
this discussion中找到了一个有用的提示:
我找到的一个解决方案(我可能会使用)是手动添加一个强制真空的cronjob. here是一个看起来很有前途的批处理脚本,但要注意强制真空可能涉及的副作用(当然取决于你的app). (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |