Re: Cannot turn track_counts on

From: Anton Shepelev <anton(dot)txt(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot turn track_counts on
Date: 2025-06-25 10:55:32
Message-ID: 20250625135532.fefb6b34b17ec19fab819982@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2025-06-25 11:55:35 Re: password rules
Previous Message raphi 2025-06-25 06:14:48 Re: password rules