Adrian Klaver:
> Anton Shepelev:
>
> > have a Postgres sever with the 'track_counts'
> > setting stuck in 'off'.
> > [...]
> > name| track_counts
> > setting | on
> > source | override
>
> This shows a setting of 'on&#x
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
What does 'o
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
Adrian Klaver to Anton Shepelev:
> >db=# show shared_preload_libraries;
> > shared_preload_libraries
> >---
> > online_analyze, plantuner
>
> Are you running PostgresPro?
>
> Both those modules are associated with
Adrian Klaver:
> Anton Shepelev:
>
> > Have you any further ideas how to turn track_counts on?
>
> It is matter of finding out what is setting?:
>
> source | override
Indeed, I having begun with this crucial question.
> There is something different about your
Daniel Gustafsson:
> Also, is this by any chance a managed instance like Amazon
> RDS or Azure, or is it a local database under your
> control?
It is a normal installation on a Linux machine, and my
company has full root access to it over SSH. Because of
strict security measures, however, only a
Adrian Klaver to Anton Shepelev:
> The below does not look like a Postgres message to me.
>
> > You need to install postgresql-server-dev-NN for
> > building a server-side extension or libpq-dev for
> > building a client-side application.
Yet that is what we get for `pg_
I wrote:
> I will test if clearing shared_preload_libraries and
> restarting Postgres has any effect on track_counts, just
> in case.
Nope, it didn't unstick track_counts:
db=# show shared_preload_libraries ;
-[ RECORD 1 ]+-
shared_preload_libraries |
db=# select * from pg_s
Adrian Klaver:
> Found it. It is coming from the Debian postgresql-common
> packaging.
>
> /usr/bin/pg_config is wrapper that contains:
>
> #!/bin/sh
>
> # If postgresql-server-dev-* is installed, call pg_config from the latest
> # available one. Otherwise fall back to libpq-dev's version.
Ah,
