Michał SobczakArchitecture · IT infrastructure · DevOps · Security · AI/ML

pg_stat_statements must be loaded via shared_preload_libraries

By Updated 1 min read

Latest Clustercontrol – version 1.9.4 – installation somehow requires pg_stat_statements to be activated in PostgreSQL 14. I have never noticed it before, both on 9.6, 12 and 14. This is simple fix. Change postgresql.conf configuration file (which should be either in /etc or /var/lib/ in standard package installations):

Text
shared_preload_libraries = 'pg_stat_statements'

Then activate extension in psql:

SQL
CREATE EXTENSION pg_stat_statements;

Restart server and you are done.

View as Markdown

All the content on this website is licensed under Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0). Cite as: Michał Sobczak, “pg_stat_statements must be loaded via shared_preload_libraries”, 20 August 2022, https://michalasobczak.pl/posts/pg_stat_statements-must-be-loaded-via-shared_preload_libraries.html

Related articles

  1. Technology1 min

    IP2Location – complete IPv4 ranges ingestion

    IP2Location is a IP address databases where you can find the latest IP to location associations. The complete IPv4 range is 4 294 967 296 addresses which is 32 bit. IP2Location contains 4 291 944 710 addresses which is a little less.

  2. Technology3 min

    PostgreSQL manual partitioning

    Have you ever wondered how many tables can we create and use in PostgreSQL database server? Shall we call them partitions or shards? Why not to use built-in “automatic” partitioning? Partitions or shards? Lets first define the difference between partitions and shards.