| From: | BUBACZ Martin <martin(dot)bubacz(at)axa(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | AW: Update pg_stat_monitor failed |
| Date: | 2026-11-05 14:35:07 |
| Message-ID: | ZR6PR04MB642637965A11A4AAC8327EB0EBE3772@ZR6PR04MB642637.eurprd04.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
One additional info to below, when I check libraries in /usr/pgsql-16/lib I see that permission on pg_stat_monitor.so is set to 644 all others have 755. But even change on permission doesn't solve the issue.
This is the Linux distro:
[root lib]# uname -a
Linux xxxx.xxxxx.xxxx 5.14.0-687.56.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Oct 6 21:51:31 EDT 2026 x86_64 x86_64 x86_64 GNU/Linux
Regards,
martin
Internal
Von: BUBACZ Martin <martin(dot)bubacz(at)axa(dot)com>
Gesendet: Donnerstag, 5. November 2026 11:53
An: pgsql-general(at)lists(dot)postgresql(dot)org
Betreff: Update pg_stat_monitor failed
Hi,
I'm fairly new to postgresql and this is maybe a stupid question (sorry beforehand): I'm trying to install pg_stat_monitor_16-2.4.0-1PGDG.rhel9.8.x86_64 on rhel 9.8 and postgresql 16.9.3 and I receive the message below when updating existing version with "alter extension pg_stat_monitor update".
ERROR: could not load library "/usr/pgsql-16/lib/pg_stat_monitor.so": /usr/pgsql-16/lib/pg_stat_monitor.so: undefined symbol: palloc0_mul
yum info pg_stat_monitor_16-2.4.0-1PGDG.rhel9.8.x86_64
Last metadata expiration check: 2:21:52 ago on Thu 05 Nov 2026 08:41:50 AM CET.
Installed Packages
Name : pg_stat_monitor_16
Version : 2.4.0
Release : 1PGDG.rhel9.8
Architecture : x86_64
Size : 118 k
Source : pg_stat_monitor_16-2.4.0-1PGDG.rhel9.8.src.rpm
Repository : @System
Summary : PostgreSQL Query Performance Monitoring Tool
URL : https://github.com/percona/pg_stat_monitor<https://urldefense.com/v3/__https:/github.com/percona/pg_stat_monitor__;!!BnkV9pdh5V0!AiIleYA2HYxnA8XVPSEyZO3-ZJMM-as7GnEVhIoto_yI2gbFrDAKQMhbaRWE3oHEHifsJJnUxsjfIfuLMDEcpec$>
License : PostgreSQL
This version is running fine: pg_stat_monitor_16-2.2.0-1PGDG.rhel9.x86_64.rpm
Can someone advice?
Thank you.
Regards,
martin
[cid:image001(dot)jpg(at)01DD6D3B(dot)3B8F0670]
Martin BUBACZ
Database Administrator (Oracle)
Global Intermediate Products Oracle
Global Service Operations
AXA Group Operations
AXA Group Operations
Colonia-Allee 10-20
51067 Köln
Germany
Tel.: +49 221 148 21934
Fax: +49 221 148 44 21934
martin(dot)bubacz(at)axa(dot)com<mailto:martin(dot)bubacz(at)axa(dot)com>
axa.de / axa.be<http://www.axa.de/>
[cid:image002(dot)png(at)01DD6D3B(dot)3B8F0670]<https://urldefense.com/v3/__https:/www.facebook.com/AXA.de__;!!BnkV9pdh5V0!AiIleYA2HYxnA8XVPSEyZO3-ZJMM-as7GnEVhIoto_yI2gbFrDAKQMhbaRWE3oHEHifsJJnUxsjfIfuLj063Ymg$> [cid:image003(dot)png(at)01DD6D3B(dot)3B8F0670] <https://urldefense.com/v3/__https:/twitter.com/axadeutschland__;!!BnkV9pdh5V0!AiIleYA2HYxnA8XVPSEyZO3-ZJMM-as7GnEVhIoto_yI2gbFrDAKQMhbaRWE3oHEHifsJJnUxsjfIfuL4dVx_DQ$> [cid:image004(dot)png(at)01DD6D3B(dot)3B8F0670] <https://urldefense.com/v3/__https:/www.xing.com/companies/axa__;!!BnkV9pdh5V0!AiIleYA2HYxnA8XVPSEyZO3-ZJMM-as7GnEVhIoto_yI2gbFrDAKQMhbaRWE3oHEHifsJJnUxsjfIfuLG-FRHso$> [cid:image005(dot)png(at)01DD6D3B(dot)3B8F0670] <https://urldefense.com/v3/__https:/www.instagram.com/axa_deutschland__;!!BnkV9pdh5V0!AiIleYA2HYxnA8XVPSEyZO3-ZJMM-as7GnEVhIoto_yI2gbFrDAKQMhbaRWE3oHEHifsJJnUxsjfIfuL9oF3IlY$>
Please consider the environment before printing this e-mail. Thank you.
Planned Absence: 18.12.2026-03.01.2027
Internal
=========================================================================
AXA Group Operations Germany GmbH
Sitz der Gesellschaft: Köln
Handelsregister: Köln HR B Nr. 22372
Geschäftsführer: Helmut Schmidt
-------------------------------------------------------------------------
Der Inhalt dieser E-Mail ist vertraulich und ausschliesslich fuer den
bezeichneten Adressaten oder dessen Vertreter bestimmt. Sollten Sie
nicht der vorgesehene Adressat dieser E-Mail oder dessen Vertreter sein,
so bitten wir Sie, sich mit dem Absender der E-Mail in Verbindung zu
setzen. Beachten Sie bitte, dass jede Form der unautorisierten Nutzung,
Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhaltes dieser
E-Mail nicht gestattet ist.
-------------------------------------------------------------------------
This message contains confidential information and is exclusively for the
person addressed or their representative. If you are not the intended
recipient of this message and its contents, please notify the sender
immediately. Any form of unauthorised use, publication, reproduction,
copying or disclosure of the content of the e-mail is not permitted.
=========================================================================
=========================================================================
AXA Group Operations Germany GmbH
Sitz der Gesellschaft: Köln
Handelsregister: Köln HR B Nr. 22372
Geschäftsführer: Helmut Schmidt
-------------------------------------------------------------------------
Der Inhalt dieser E-Mail ist vertraulich und ausschliesslich fuer den
bezeichneten Adressaten oder dessen Vertreter bestimmt. Sollten Sie
nicht der vorgesehene Adressat dieser E-Mail oder dessen Vertreter sein,
so bitten wir Sie, sich mit dem Absender der E-Mail in Verbindung zu
setzen. Beachten Sie bitte, dass jede Form der unautorisierten Nutzung,
Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhaltes dieser
E-Mail nicht gestattet ist.
-------------------------------------------------------------------------
This message contains confidential information and is exclusively for the
person addressed or their representative. If you are not the intended
recipient of this message and its contents, please notify the sender
immediately. Any form of unauthorised use, publication, reproduction,
copying or disclosure of the content of the e-mail is not permitted.
=========================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2026-11-05 14:40:02 | Re: Update pg_stat_monitor failed |
| Previous Message | BUBACZ Martin | 2026-11-05 10:53:17 | Update pg_stat_monitor failed |