shared_preload_libraries and pg_stat_statements - Mailing list 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