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
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 |