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(dot)klaver(at)aklaver(dot)com