shared_preload_libraries and pg_stat_statements
От | Armand Pirvu (gmail) |
---|---|
Тема | shared_preload_libraries and pg_stat_statements |
Дата | |
Msg-id | 4463AE61-FDDA-4A60-9D6A-1EB88486DDD7@gmail.com обсуждение исходный текст |
Ответы |
Re: shared_preload_libraries and pg_stat_statements
|
Список | 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
В списке pgsql-novice по дате отправления: