Re: Issue enabling track_counts to launch autovacuum in 9.4.5 - Mailing list pgsql-general

From Derek Elder
Subject Re: Issue enabling track_counts to launch autovacuum in 9.4.5
Date
Msg-id CAM3xazUiRAowPjoPxbvCODdet3eJ6-e2vy9GvW17m0C8=VL7_Q@mail.gmail.com
Whole thread Raw
In response to Re: Issue enabling track_counts to launch autovacuum in 9.4.5  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Issue enabling track_counts to launch autovacuum in 9.4.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@gmail.com> wrote:

On Wed, Mar 2, 2016 at 2:29 PM, Derek Elder <dereke@mirthcorp.com> 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.

pgsql-general by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: Re: Slow Query - Postgres 9.2
Next
From: Derek Elder
Date:
Subject: Re: Issue enabling track_counts to launch autovacuum in 9.4.5