Date: Wed, 25 Jun 2025 13:55:32 +0300
From: Anton Shepelev <anton.txt@gmail.com>
To: pgsql-general@postgresql.org
Subject: Re: Cannot turn track_counts on
Message-Id: <20250625135532.fefb6b34b17ec19fab819982@gmail.com>
In-Reply-To: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com>
References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/20250625135532.fefb6b34b17ec19fab819982%40gmail.com>
Precedence: bulk

I wrote:

> I have a Postgres sever with the 'track_counts' setting
> stuck in 'off'.  [...]

I ghosted-out from this thread with my tail between my legs,
because the only collegue who had access to the affected
machine had no time to spare and then went of vacation.  He
has returned now, and I have had the luck to find the
problem.  The log had the following messages:

  LOG    : disabling statistics collector for lack of working socket
  WARNING: autovacuum not started because of misconfiguration

Asking around, I was informed that an ugnly cructch had been
instated on the machine: the localhost loopback removed from
/etc/hosts, to work around some network-related problem.

I explained to the person responsible that it is the wrong
way of doing one's work, and demanded they return localhost
to the hosts file and restart the network.  track_counts is
on now.

-- 
()  ascii ribbon campaign -- against html e-mail
/\  www.asciiribbon.org   -- against proprietary attachments