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" >>  (otheus uibk <otheus.uibk@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Re[2]: [BUGS] Segfault in MemoryContextAlloc
Следующее
От: fotonszekta@gmail.com
Дата:
Сообщение: BUG #13892: SELECT FALSE = FALSE = TRUE; error