Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1txYDU-00B4aX-F4 for pgsql-admin@arkaria.postgresql.org; Wed, 26 Mar 2025 21:23:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1txYDT-00AmsE-4U for pgsql-admin@arkaria.postgresql.org; Wed, 26 Mar 2025 21:23:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1txYDS-00Ams5-LR for pgsql-admin@lists.postgresql.org; Wed, 26 Mar 2025 21:23:14 +0000 Received: from mail-ua1-x935.google.com ([2607:f8b0:4864:20::935]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1txYDQ-001JHF-1q for pgsql-admin@lists.postgresql.org; Wed, 26 Mar 2025 21:23:13 +0000 Received: by mail-ua1-x935.google.com with SMTP id a1e0cc1a2514c-86d75f4e9a1so146425241.3 for ; Wed, 26 Mar 2025 14:23:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743024191; x=1743628991; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=U9cyfeUpxrrhEmnV1eGqJMMPbo/HhnUpv9woxw8yf8M=; b=IO4mUm39eihdHqK/yii+eV0FRwSFnzAZYh75BKAh3terQTYeFUJ4JmVsl+JyPzkVBQ Ogp8x10A8hYTHSnaFlLxmC6SGspVcocJgsc65Opuyuei1ll80QLpU7FPB0w6f2W080Wb cPrE6lhuv0/KUPJrcoNX2mMgVx4vYNzPArtmlFFbEqyf6lIcMn0CQrxP/4yI7i3XVA3m L1GBr1NOPbhJ8zvT+8V+u7dpjUp8nBYJTO1qPhgdFjbRnqiFOheE+fHDZAUNSoLxNt// YNnbdFpB2hUWtAe3o9TNPJm2UWUmHMYmb6PsHG0IDF3VcIuRET4PDRF/3FKfpEmwTu9M gYUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743024191; x=1743628991; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=U9cyfeUpxrrhEmnV1eGqJMMPbo/HhnUpv9woxw8yf8M=; b=J3n6eDL54QRaVX6z3h6tCcWnQuJ3gGGXcP+iqO1vzOkDMi2D+Z1KKBNbUiLio/p9Hn rIB7ma7iknF98TvQmgX2QocrW/KqHyZQMgqWvDtmrG2YPDRRyOISmifj2VGNQC32u8wt 0ZiWlKt/7HNaQy60mvcrDQ7nh1KIHNfEEQCtWmazqY1xf+tk1JqNxoWCfx9v4+l4XpK/ juiIBV5lLmUGKcXRTNVyykiRYPPIIf6+NDARSFUu0OuF081K/gHYxfl0fh+h1JqauYyE p38HCby7AiYIGHlCt3Up2JpxQh3oWV7g8LHsWNF0eUM86n0YxUFfFv7RyTh9iEAYZaV/ MUxg== X-Gm-Message-State: AOJu0YzQpCH0rlfX4sctdaOFKjylsOUgAsb44YrkKNm0/NGLoczYuffy h4PWX9rR33om8Cm0RSoooychtEQE448r/Gf/HcZGJV+Tr4ALTcT8mJRAEMoI+BxkQNXnLlK3PYM vHuj+Y34qQ0wKYNPL2TJGv8g4sk2F238n X-Gm-Gg: ASbGncsC6y4ouO+WI1cw8bjgkB8eGaXpZy1o/gHtYvdUdRTRq/OGwDZFrKBB7IOPuu1 Km7GSCMEZydXu0SxKKl0GakFThjsWaJZ5x7TfFb9H8Fuiy/T6fU2f/OJ8+eWp7lRLqLGac3Qbku 8V3wLWG7Fr2BmvrNubqpRt9NgsBXznP3dPRvrNAqfM2C1D3qefihg5Fhn8+8E= X-Google-Smtp-Source: AGHT+IEttvarKgt+BN5FtxtkBH2bK/dVQvHTrWbYxCi6FOtISh+kQHBYH6ugAFDwPbaqKZ4oRGkWDGhDoBhAknJYLuE= X-Received: by 2002:a05:6102:2acb:b0:4c1:99cc:792 with SMTP id ada2fe7eead31-4c586fa8646mr1445977137.13.1743024191301; Wed, 26 Mar 2025 14:23:11 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Mauricio Fernandez Date: Wed, 26 Mar 2025 18:23:00 -0300 X-Gm-Features: AQ5f1Jr5B8AEvvUGUhA4lZQDfMPPbTG-NeX6ogL-hujmWRiJglOH1x3mcOPFlao Message-ID: Subject: Re: Few extensions, pg_stat_statements not available To: Ron Johnson Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000c1f5140631457135" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c1f5140631457135 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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-red= hat-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=3DOracle Linux 9 CodeReady Builder ($basearch) - (Unsupported) baseurl=3Dhttps://yum $ociregion.$ocidomain/repo/OracleLinux/OL9/codeready/builder/$basearch/ gpgkey=3Dfile:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle gpgcheck=3D1 *enabled=3D1* [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=C3=A9, 26 mar 2025 a las 18:08, Ron Johnson () escribi=C3=B3: > On Wed, Mar 26, 2025 at 4:58=E2=80=AFPM 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 becau= se >> 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=3D# 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 , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --000000000000c1f5140631457135 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Ron, thanks for the answer.

I've= installed postgresql following the instruction in=C2=A0https://www.po= stgresql.org/download/linux/redhat/ for redhat 9 and postgresql 17

[root@pgsql01 ~]$ sudo dnf install -y https://download.postgresql.org/pu= b/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 af= ter I've created the cluster and master /standby replication with repmg= r I have installed dnf install postgresql17-devel following system_stats in= stallation=C2=A0instructions

[root@pgsql01 ~]# =C2= =A0vi /etc/yum.repos.d/oracle-linux-ol9.repo

[ol9_codeready_builder]=
name=3DOracle Linux 9 CodeReady Builder ($basearch) - (Unsupported)
= baseurl=3Dhttps://yum$ociregi= on.$ocidomain/repo/OracleLinux/OL9/codeready/builder/$basearch/
gpgkey= =3Dfile:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=3D1
enabled= =3D1

[root@pgsql01 ~]# dnf install postgresql17-devel
[root@p= gsql01 ~]# dnf install redhat-rpm-config

Should I = install postgresql17-contrib package??=C2=A0

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

than= ks=C2=A0

kind regards

MF<= /div>

El mi=C3=A9, 26 mar 2025 a las 18:08, Ron Johnson (<ronljohnsonjr@gmail.com&g= t;) escribi=C3=B3:
On Wed, Mar 26, 2025 at 4:58=E2=80=AFP= M Mauricio Fernandez <mmauricio.fernandez@gmail.com> wrote:
Hi community

I've been investigating abou= t postgresql monitoring tools and I've installed a couple of extensions= : system_stats and pg_stat_monitor.Then I tried to enable pg_stat_statement= s and postgresql could no restart because lack of extension file

FAT= AL: =C2=A0could not access file "pg_stat_statements": No such fil= e or directory

I don't know why there are so few extensions avai= lable

postgres=3D# select * from pg_available_extensions;
=C2=A0 = =C2=A0 =C2=A0 name =C2=A0 =C2=A0 =C2=A0 | default_version | installed_versi= on | comment =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0
--= ---------------+-----------------+-------------------+---------------------= ----------------------------------------------------
=C2=A0plpgsql =C2= =A0 =C2=A0 =C2=A0 =C2=A0 | 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | = 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | PL/pgSQL procedural = language
=C2=A0system_stats =C2=A0 =C2=A0| 3.0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | 3.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | = EnterpriseDB system statistics for PostgreSQL
=C2=A0repmgr =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0| 5.5 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Replication m= anager for PostgreSQL
=C2=A0pg_stat_monitor | 2.1 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 | The pg_stat_monitor is a PostgreSQL Query Performance Monitori= ng tool.....
(4 rows)


[postgres@pgsql01 data]$ ls -l /usr/pgs= ql-17/share/extension/
total 256
-rw-r--r--. 1 root root =C2=A09636 F= eb 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]=C2=A0
-rw-r--r--. 1 root root =C2=A06113 Mar 20 16:56 system_sta= ts--3.0.sql
-rw-r--r--. 1 root root =C2=A0 167 Mar 20 16:56 system_stats= .control
-rw-r--r--. 1 root root =C2=A0 373 Mar 20 16:56 uninstall_syste= m_stats.sql
[postgres@pgsql01 data]$

I would ap= preciate any tips or guidance=C2=A0

=

How did you install?
If usin= g packages, what packages did you install?

(On RHE= L, it's in the postgresqlXX-contrib package.)

--
Death to <Redacted>, and butter sauc= e.
Don't boil me, I'm still alive.
<Redacted>= ; lobster!
--000000000000c1f5140631457135--