Search Postgresql Archives

Re: Issue enabling track_counts to launch autovacuum in 9.4.5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



That was indeed the root cause. The /etc/hosts file on the server had incorrect permissions which caused localhost to not resolve.

Going to file this away in the knowledge base. Thank you so much for the help David!

Derek

On Wed, Mar 2, 2016 at 1:37 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wed, Mar 2, 2016 at 2:29 PM, Derek Elder <dereke@xxxxxxxxxxxxx> wrote:

2016-03-02 14:58:09 EST [14366][8-1] LOG: could not resolve "localhost": Name or service not known
2016-03-02 14:58:09 EST [14366][9-1] LOG: disabling statistics collector for lack of working socket

I'm reasonably certain the above is the root of the problem.
 

2016-03-02 14:58:09 EST [14366][10-1] WARNING: autovacuum not started because of misconfiguration
2016-03-02 14:58:09 EST [14366][11-1] HINT: Enable the "track_counts" option.

​This is simply a symptom.  The hint is misleading in this situation.

Someone more informed can hopefully offer more guidance fixing your localhost ​resolution problem.

David J.



This message, and any documents attached hereto, may contain confidential or proprietary information intended only for the use of the addressee(s) named above or may contain information that is legally  privileged. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message and any copies immediately thereafter.  Thank you for your cooperation.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux