Thread: << unrecognized configuration parameter "pg_stat_statements.track" >>
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: # strings /usr/lib64/pgsql/pg_stat_statements.so |grep track pgstat_track_activity_query_size pg_stat_statements.track Sets the maximum number of statements tracked by pg_stat_statements. Selects which statements are tracked by pg_stat_statements. Selects whether utility commands are tracked by pg_stat_statements. pg_stat_statements.track_utility -- Otheus otheus.uibk@gmail.com otheus.shelling@uibk.ac.at
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
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@anarazel.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.uibk@gmail.com otheus.shelling@uibk.ac.at
Hi, On 2016-01-27 15:49:22 +0100, otheus uibk wrote: > 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. Meh. It used to be general requirement to add extension prefixes to custom_variable_classes, it wasn't pg_stat_statement specific. And it's a short paragraph. But either way, 9.1 is soon to be EOLed, I don't see much point in working on its docs. Andres