Re: Cannot turn track_counts on

On 4/17/25 07:05, Anton Shepelev wrote:
> Tom Lane to Anton Shepelev:
> 
>>> I have a Postgres sever with the 'track_counts' setting
>>> stuck in 'off'.  [...]
>>
>> I am fairly certain that there is nothing in core Postgres
>> that would do that.  PGC_S_OVERRIDE is used to lock down
>> the values of certain variables that shouldn't be allowed
>> to change, but track_counts surely isn't one of those.
>> And a quick grep through the code finds nothing applying
>> PGC_S_OVERRIDE to it.
> 
> Thanks for checking it, Tom.
> 
>> What extensions do you have installed?
> 
> Nothing much:
> 
>    db=# show shared_preload_libraries;
>     shared_preload_libraries
>    ---------------------------
>     online_analyze, plantuner

Are you running PostgresPro?

Both those modules are associated with it:

https://postgrespro.com/docs/postgrespro/17/contrib.html

If you are you might want to talk to their tech support.

> 
>    db=# \dx
>                     List of installed extensions
>      Name   | Version |   Schema   |         Description
>    ---------+---------+------------+------------------------------
>     plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com