Re: Few extensions, pg_stat_statements not available

Hi Ron, thanks for the answer.

I've installed postgresql following the instruction in
https://www.postgresql.org/download/linux/redhat/ for redhat 9 and
postgresql 17

[root(at)pgsql01 ~]$ sudo dnf install -y
https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
[root(at)pgsql01 ~]# sudo dnf -qy module disable postgresql
[root(at)pgsql01 ~]# sudo dnf install -y postgresql17-server

Then after I've created the cluster and master /standby replication with
repmgr I have installed dnf install postgresql17-devel following
system_stats installation instructions

[root(at)pgsql01 ~]# vi /etc/yum.repos.d/oracle-linux-ol9.repo

[ol9_codeready_builder]
name=Oracle Linux 9 CodeReady Builder ($basearch) - (Unsupported)
baseurl=https://yum
$ociregion.$ocidomain/repo/OracleLinux/OL9/codeready/builder/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1

*enabled=1*
[root(at)pgsql01 ~]# dnf install postgresql17-devel
[root(at)pgsql01 ~]# dnf install redhat-rpm-config

Should I install postgresql17-contrib package??

[root(at)pgsql01 ~]# dnf install postgresql17-contrib

thanks

kind regards

MF

El mié, 26 mar 2025 a las 18:08, Ron Johnson (<ronljohnsonjr(at)gmail(dot)com>)
escribió:

> 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!
>