Re: << unrecognized configuration parameter "pg_stat_statements.track" >> - Mailing list pgsql-bugs

From Andres Freund
Subject Re: << unrecognized configuration parameter "pg_stat_statements.track" >>
Date
Msg-id 20160127130745.GB17919@awork2.anarazel.de
Whole thread Raw
In response to << unrecognized configuration parameter "pg_stat_statements.track" >>  (otheus uibk <otheus.uibk@gmail.com>)
Responses Re: << unrecognized configuration parameter "pg_stat_statements.track" >>
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Re[2]: [BUGS] Segfault in MemoryContextAlloc
Next
From: fotonszekta@gmail.com
Date:
Subject: BUG #13892: SELECT FALSE = FALSE = TRUE; error