Postgres Pro
Downloads
Home   >   mailing lists

Re: Few extensions, pg_stat_statements not available - Mailing list pgsql-admin

From Mauricio Fernandez
Subject Re: Few extensions, pg_stat_statements not available
Date
Msg-id CAMdfv4Uz+GRsRq7ZVeWiZ3UyU3cJmnahyDrqdChLTuvTm0dyqQ@mail.gmail.com
Whole thread Raw
In response to Re: Few extensions, pg_stat_statements not available  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Few extensions, pg_stat_statements not available
List pgsql-admin
Tree view
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@pgsql01 ~]$ sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
[root@pgsql01 ~]# sudo dnf -qy module disable postgresql
[root@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@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@pgsql01 ~]# dnf install postgresql17-devel
[root@pgsql01 ~]# dnf install redhat-rpm-config

Should I install postgresql17-contrib package?? 

[root@pgsql01 ~]# dnf install postgresql17-contrib

thanks 

kind regards

MF

El mié, 26 mar 2025 a las 18:08, Ron Johnson (<ronljohnsonjr@gmail.com>) escribió:
On Wed, Mar 26, 2025 at 4:58 PM Mauricio Fernandez <mmauricio.fernandez@gmail.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@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@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!

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Few extensions, pg_stat_statements not available
Next
From: Laurenz Albe
Date:
Subject: Re: Few extensions, pg_stat_statements not available