public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Anton Shepelev <[email protected]>
Cc: [email protected]
Subject: Re: Cannot turn track_counts on
Date: Tue, 22 Apr 2025 08:21:09 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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
[email protected]

view thread (10+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Cannot turn track_counts on
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox