Date: Tue, 22 Apr 2025 11:31:30 +0300
From: Anton Shepelev <anton.txt@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Cannot turn track_counts on
Message-Id: <20250422113130.7519e029c3c29c07b08b2b66@gmail.com>
In-Reply-To: <91d7fc8f-58c5-4932-9f23-32f2341776b4@aklaver.com>
References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com>
	<1900177.1744815217@sss.pgh.pa.us>
	<20250417170534.b2e919e950b77c4d4dbd5483@gmail.com>
	<1a99f488-9d24-41d1-a1a5-17ea4ce87899@aklaver.com>
	<20250418002307.a029379d2c0f781ca7726f91@gmail.com>
	<20250421194644.cdd5064d94d58edd62e54dc1@gmail.com>
	<91d7fc8f-58c5-4932-9f23-32f2341776b4@aklaver.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/20250422113130.7519e029c3c29c07b08b2b66%40gmail.com>
Precedence: bulk

Adrian Klaver:

> Anton Shepelev:
>
> > Have you any further ideas how to turn track_counts on?
>
> It is matter of finding out what is setting?:
>
> source          | override

Indeed, I having begun with this crucial question.

> There is something different about your setup, as here on
> Ubuntu(which uses the Debian packaging) I see:
> [...]

Yes.  It is on on your side, and pgsql shows NULL values as
NULL.  Can the latter be due to a differnce in Postgres
versions, for mine is 11.21 (as I have reported before)?

We have several other servers with identical versions of the
OS and PostgreSQL:

  user@DC:/opt/sva$ cat /etc/issue
  Astra Linux 1.7.5
  user@xx:/opt/sva$ apt show postgresql
  Package: postgresql
  Version: 11+225astra3
  Priority: optional
  Section: database
  Source: postgresql-common (225astra3)
  Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>

  user@xx:/opt/sva$ psql -V
  psql (PostgreSQL) 11.21 (Debian 1:11.21-astra.se6+ci1)

but `track_counts' is stuck off only on one.

A complete reinstall with purging of all configuration data
comes to mind, but it is a last-resort measure, as the
system is a production one, and actively used.

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