Re: Issue enabling track_counts to launch autovacuum in 9.4.5

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Derek Elder <dereke(at)mirthcorp(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 21:37:02
Message-ID: CAKFQuwZN5N_KAyPviMhA+X5Qzs36=Vwyc+gpw3aHbN1L_wwfgA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

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