shared_preload_libraries and pg_stat_statements

From: "Armand Pirvu (gmail)" <armand(dot)pirvu(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: shared_preload_libraries and pg_stat_statements
Date: 2015-09-04 20:03:03
Message-ID: 4463AE61-FDDA-4A60-9D6A-1EB88486DDD7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all

In my postgresql.conf I have

shared_preload_libraries = 'pg_stat_statements, pg_shard' # (change requires restart)
pg_stat_statements.max = 10000
pg_stat_statements.track = all

The server restarts ok, created the extension fine, but

postgres=# select * from pg_stat_statements;
ERROR: pg_stat_statements must be loaded via shared_preload_libraries

And more

postgres=# SHOW shared_preload_libraries;
shared_preload_libraries
--------------------------
pg_shard
(1 row)

postgres=# select * from pg_extension;
extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
--------------------+----------+--------------+----------------+------------+---------------------+--------------
plpgsql | 10 | 11 | f | 1.0 | |
pg_shard | 10 | 2200 | t | 1.1 | {16661,16669,16682} | {"","",""}
pg_stat_statements | 10 | 2200 | t | 1.2 | |

Could it be a collision from pg_shard and pg_stat_statements from the same value of extnamespace ?

Thanks
-- Armand

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2015-09-04 20:18:36 Re: shared_preload_libraries and pg_stat_statements
Previous Message Albe Laurenz 2015-09-04 09:50:02 Re: Trouble including pg_type.h