I wrote:
> I have a Postgres sever with the 'track_counts' setting
> stuck in 'off'. [...]
I ghosted-out from this thread with my tail between my legs,
because the only collegue who had access to the affected
machine had no time to spare and then went of vacation. He
has returned now, and I hav
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
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,
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 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_
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
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:
> 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
10 matches
Mail list logo
