Re: << unrecognized configuration parameter "pg_stat_statements.track" >>
От | Andres Freund |
---|---|
Тема | Re: << unrecognized configuration parameter "pg_stat_statements.track" >> |
Дата | |
Msg-id | 20160127130745.GB17919@awork2.anarazel.de обсуждение исходный текст |
Ответ на | << unrecognized configuration parameter "pg_stat_statements.track" >> (otheus uibk <otheus.uibk@gmail.com>) |
Ответы |
Re: << unrecognized configuration parameter
"pg_stat_statements.track" >>
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: