Re: << unrecognized configuration parameter "pg_stat_statements.track" >>

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

In response to

Responses

Browse pgsql-bugs by date

  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