From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | otheus uibk <otheus(dot)uibk(at)gmail(dot)com> |
Cc: | Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: << unrecognized configuration parameter "pg_stat_statements.track" >> |
Date: | 2016-01-27 13:07:45 |
Message-ID: | 20160127130745.GB17919@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Önder Kalacı | 2016-01-27 13:42:58 | Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres |
Previous Message | Pavel Stehule | 2016-01-27 13:05:46 | Re: Re[2]: [BUGS] Segfault in MemoryContextAlloc |