Re: Few extensions, pg_stat_statements not available

On Wed, Mar 26, 2025 at 4:58 PM Mauricio Fernandez <
mmauricio(dot)fernandez(at)gmail(dot)com> wrote:

> Hi community
>
> I've been investigating about postgresql monitoring tools and I've
> installed a couple of extensions: system_stats and pg_stat_monitor.Then I
> tried to enable pg_stat_statements and postgresql could no restart because
> lack of extension file
>
> FATAL: could not access file "pg_stat_statements": No such file or
> directory
>
> I don't know why there are so few extensions available
>
> postgres=# select * from pg_available_extensions;
> name | default_version | installed_version | comment
>
>
> -----------------+-----------------+-------------------+-------------------------------------------------------------------------
> plpgsql | 1.0 | 1.0 | PL/pgSQL
> procedural language
> system_stats | 3.0 | 3.0 | EnterpriseDB
> system statistics for PostgreSQL
> repmgr | 5.5 | | Replication
> manager for PostgreSQL
> pg_stat_monitor | 2.1 | | The
> pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool.....
> (4 rows)
>
>
> [postgres(at)pgsql01 data]$ ls -l /usr/pgsql-17/share/extension/
> total 256
> -rw-r--r--. 1 root root 9636 Feb 24 08:25 pg_stat_monitor--1.0--2.0.sql
> -rw-r--r--. 1 root root 12017 Feb 24 08:25 pg_stat_monitor--2.0--2.1.sql
> -rw-r--r--. 1 root root 11092 Feb 24 08:25 pg_stat_monitor--2.0.sql
> -
>
[snip]

> -rw-r--r--. 1 root root 6113 Mar 20 16:56 system_stats--3.0.sql
> -rw-r--r--. 1 root root 167 Mar 20 16:56 system_stats.control
> -rw-r--r--. 1 root root 373 Mar 20 16:56 uninstall_system_stats.sql
> [postgres(at)pgsql01 data]$
>
> I would appreciate any tips or guidance
>

How did you install?
If using packages, what packages did you install?

(On RHEL, it's in the postgresqlXX-contrib package.)

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!