Re: Cannot turn track_counts on

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Anton Shepelev <anton(dot)txt(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot turn track_counts on
Date: 2025-04-16 15:11:11
Message-ID: f2510b5c-9ad3-4d31-b3ff-0db3c81a1d26@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/16/25 02:27, Anton Shepelev wrote:
> Hello, all.
>
> I have a Postgres sever with the 'track_counts' setting
> stuck in 'off'. I cannot seem to enable it with either of
> a. ALTER SYSTEM,
> b. ALTER DATABASE,
> c. ALTER USER,
> d. or plain SET.
>
> pg_settings shows:
>
> name | track_counts
> setting | on
> source | override

This shows a setting of 'on' not the 'off' you mention in the first
paragraph.

>
> What does 'override' mean in the 'source' column? How can I
> find where in the system this setting is overridden?
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-04-16 15:25:12 Re: Fwd: Identify system databases
Previous Message Dominique Devienne 2025-04-16 15:06:57 Re: Fwd: Identify system databases