-
Notifications
You must be signed in to change notification settings - Fork 26
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CREATE EXTENSION pg_qualstats #8
Comments
That seems strange. One reason could be that |
Great GREAT … GREAT!!!! WONDERFUL … IT’S RUNNING …. THXS A LOT ….. Last question about Explain me this topics How can change the sourcefile of shared_preload_libraries? I fill in into the /var/PostgreSQL/data/postgresql.conf the parameter. Thx a log Lorenzo SELECT name, Da: Julien Rouhaud [mailto:notifications@github.com] That seems strange. One reason could be that pg_stat_statements were added to shared_preload_libraries with an ALTER SYSTEM command, so any further change to this parameter in the postgresql.conffile would be ignored. Can you also check the sourcefile column of pg_settings, to see if t's included in postgresql.conf or postgresql.auto.conf? — |
Great GREAT … GREAT!!!! WONDERFUL … IT’S RUNNING …. THXS A LOT ….. Last question about Explain me this topics How can change the sourcefile of shared_preload_libraries? I fill in into the /var/PostgreSQL/data/postgresql.conf the parameter. Thx a log Lorenzo SELECT name, |
Sourcefile is just a column telling you which file is the last to set up a parameter. If you want to configure shared_preload_libraries with postgresql.conf instead of postgresql.auto.conf, you have to make sure you never use ALTER SYSTEM anymore to configure something after fixing it. In this case, you can do:
|
Excellent! You are the best support!!! Amazing. ☺ Da: Julien Rouhaud [mailto:notifications@github.com] Sourcefile is just a column telling you which file is the last to set up a parameter. If you want to configure shared_preload_libraries with postgresql.conf instead of postgresql.auto.conf, you have to make sure you never use ALTER SYSTEM anymore to configure something after fixing it. In this case, you can do:
— |
Thanks :) |
I have configured the extension with the following features:
. contrib + dev rpm installed done (Done
. modified postgresql.conf (add shared_preload_libraries = 'pg_stat_statements,pg_qualstats') (Done)
. make install pg_qualstat.c (Done)
.restart the instance (pg_ctl -D restart (Done)
It seems like good, but when I would like to add the EXTENSION Postgres write this Error:
postgres=# CREATE EXTENSION pg_qualstats ;
ERROR: This module can only be loaded via shared_preload_libraries
Time: 3.347 ms
Could you please help me?
Any suggestions will be accepted.
Regards.
Lorenzo
Extension installed:
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
--------------------+---------+------------+-----------------------------------------------------------
adminpack | 1.0 | pg_catalog | administrative functions for PostgreSQL
pg_stat_kcache | 2.0.2 | public | Kernel cache statistics gathering
pg_stat_statements | 1.3 | public | track execution statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgres=# show shared_preload_libraries;
shared_preload_libraries
pg_stat_statements
(1 row)
select name,pending_restart, from pg_settings where name in ('shared_preload_libraries');
--------------------------+-----------------
shared_preload_libraries | f
The text was updated successfully, but these errors were encountered: