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
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 |