Re: Issue enabling track_counts to launch autovacuum in 9.4.5

From: Derek Elder <dereke(at)mirthcorp(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Issue enabling track_counts to launch autovacuum in 9.4.5
Date: 2016-03-02 22:32:31
Message-ID: CAM3xazUiRAowPjoPxbvCODdet3eJ6-e2vy9GvW17m0C8=VL7_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Derek Elder 2016-03-02 22:33:15 Re: Issue enabling track_counts to launch autovacuum in 9.4.5
Previous Message drum.lucas@gmail.com 2016-03-02 21:59:36 Re: Slow Query - Postgres 9.2