Re: Cannot turn track_counts on

From: Anton Shepelev <anton(dot)txt(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot turn track_counts on
Date: 2025-04-22 08:31:30
Message-ID: 20250422113130.7519e029c3c29c07b08b2b66@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)DC:/opt/sva$ cat /etc/issue
Astra Linux 1.7.5
user(at)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(at)tracker(dot)debian(dot)org>

user(at)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yongye Serkfem 2025-04-22 11:28:33 Oracle_fdw
Previous Message David G. Johnston 2025-04-22 05:02:21 Re: sequence on daily log partitioned table