public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Few extensions, pg_stat_statements not available
Date: Wed, 26 Mar 2025 17:08:00 -0400
Message-ID: <CANzqJaCCRXGcStzd+PPSiP34SfcGE5AeCeVbUeoqPv_P+Uxycg@mail.gmail.com> (raw)
In-Reply-To: <CAMdfv4UcNc7pY5RL-BCq+9LHJA-7h1L6T1AGQRHh6Yy3PGUshg@mail.gmail.com>
References: <CAMdfv4UcNc7pY5RL-BCq+9LHJA-7h1L6T1AGQRHh6Yy3PGUshg@mail.gmail.com>
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]
Subject: Re: Few extensions, pg_stat_statements not available
In-Reply-To: <CANzqJaCCRXGcStzd+PPSiP34SfcGE5AeCeVbUeoqPv_P+Uxycg@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