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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: Trouble including pg_type.h
Следующее
От: Tom Lane
Дата:
Сообщение: Re: shared_preload_libraries and pg_stat_statements