Re: << unrecognized configuration parameter "pg_stat_statements.track" >>

From: otheus uibk <otheus(dot)uibk(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: << unrecognized configuration parameter "pg_stat_statements.track" >>
Date: 2016-01-27 14:49:22
Message-ID: CALbQNd3CUZXFW0miH0HUTQ9QGt+ih3LGb3BsmF7QJm3PERHj=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thank you, Andres.

What a doozie! Documenting such a requirement in such a fashion (at the end
of of a section) is a golden example of obfuscation and
cryptodocumentation. Perhaps someone with wisdom will see fit to move the
relevant paragraph to the top of the "Configuration parameters" section,
instead of at the end.

On Wed, Jan 27, 2016 at 2:07 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:

> Hi,
>
> On 2016-01-27 14:03:37 +0100, otheus uibk wrote:
> > Works correctly in 9.2.10 but not in 9.1.8. Is this a known bug for 9.1.8
> > that has an upstream fix? There is nothing in the 9.1.x release notes
> > indicating such.
> >
> > shared_preload_libraries='pg_stat_statements'
> > track_activity_query_size=2048
> > pg_stat_statements.track = all
> >
> >
> > The above configuration in 9.1.8 fails with "unrecognized configuration
> > parameter "pg_stat_statements.track""
> > When the "track" option is removed, startup is normal. When added back
> and
> > reload issued, again the complaint.
> >
> > The shared library does indeed have the option string:
>
> As documented in 9.1's manual, back then you still needed to configure
> http://www.postgresql.org/docs/9.1/static/pgstatstatements.html :
> # postgresql.conf
> shared_preload_libraries = 'pg_stat_statements'
> custom_variable_classes = 'pg_stat_statements'
> pg_stat_statements.max = 10000
> pg_stat_statements.track = all
>
> Regards,
>
> Andres
>

--
Otheus
otheus(dot)uibk(at)gmail(dot)com
otheus(dot)shelling(at)uibk(dot)ac(dot)at

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2016-01-27 14:54:04 Re: << unrecognized configuration parameter "pg_stat_statements.track" >>
Previous Message Önder Kalacı 2016-01-27 13:42:58 Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres