public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mauricio Fernandez <[email protected]>
To: Ron Johnson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Few extensions, pg_stat_statements not available
Date: Wed, 26 Mar 2025 18:23:00 -0300
Message-ID: <CAMdfv4Uz+GRsRq7ZVeWiZ3UyU3cJmnahyDrqdChLTuvTm0dyqQ@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaCCRXGcStzd+PPSiP34SfcGE5AeCeVbUeoqPv_P+Uxycg@mail.gmail.com>
References: <CAMdfv4UcNc7pY5RL-BCq+9LHJA-7h1L6T1AGQRHh6Yy3PGUshg@mail.gmail.com>
<CANzqJaCCRXGcStzd+PPSiP34SfcGE5AeCeVbUeoqPv_P+Uxycg@mail.gmail.com>
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.rp...
[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 (<[email protected]>)
escribió:
> On Wed, Mar 26, 2025 at 4:58 PM Mauricio Fernandez <
> [email protected]> 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!
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Few extensions, pg_stat_statements not available
In-Reply-To: <CAMdfv4Uz+GRsRq7ZVeWiZ3UyU3cJmnahyDrqdChLTuvTm0dyqQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox