Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Issue enabling track_counts to launch autovacuum in 9.4.5
Date
Msg-id CAKFQuwZN5N_KAyPviMhA+X5Qzs36=Vwyc+gpw3aHbN1L_wwfgA@mail.gmail.com
Whole thread Raw
In response to Issue enabling track_counts to launch autovacuum in 9.4.5  (Derek Elder <dereke@mirthcorp.com>)
Responses Re: Issue enabling track_counts to launch autovacuum in 9.4.5  (Derek Elder <dereke@mirthcorp.com>)
List pgsql-general
Tree view

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.

pgsql-general by date:

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