Re: Cannot turn track_counts on

On 4/22/25 01:31, Anton Shepelev wrote:
> Adrian Klaver:

> 
>> 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)?

No that is because I have my ~/.psqlrc set up with:

\pset null 'NULL'

 From here:

https://www.postgresql.org/docs/current/app-psql.html

See the:

Meta-Commands
\pset

section

as well as

Files

psqlrc and ~/.psqlrc


>    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.
> 

Given that the Debian Postgres packaging allows you to install multiple 
clusters of a given version I would create a new 11.21 cluster as a test 
and see what track_counts is set to. That would help determine whether 
the setting is coming from the initial install. You could then add the 
other components to the cluster one by one and see if and where the 
track_counts setting changes.


-- 
Adrian Klaver
adrian.klaver@aklaver.com