Issue with installing postgres extension

[bhavani dba <dbabhavani@xxxxxxxxx>]

I am having issues with postgres extensions and I have already installed the contrib package.

thank you for the help!!

postgres=# CREATE EXTENSION pg_stat_statements;
ERROR:  could not load library "/home/postgres/bin/pgsql/15/lib/pg_stat_statements.so": /home/postgres/bin/pgsql/15/lib/pg_stat_statements.so: undefined symbol: InitMaterializedSRF
postgres=#
postgres=# exit
[postgres@postgres ~]$ rpm -q postgresql15-contrib
postgresql15-contrib-15.7-3PGDG.rhel8.x86_64
[postgres@postgres ~]$ pg_config
BINDIR = /home/postgres/bin/pgsql/15/bin
DOCDIR = /home/postgres/bin/pgsql/15/share/doc
HTMLDIR = /home/postgres/bin/pgsql/15/share/doc
INCLUDEDIR = /home/postgres/bin/pgsql/15/include
PKGINCLUDEDIR = /home/postgres/bin/pgsql/15/include
INCLUDEDIR-SERVER = /home/postgres/bin/pgsql/15/include/server
LIBDIR = /home/postgres/bin/pgsql/15/lib
PKGLIBDIR = /home/postgres/bin/pgsql/15/lib
LOCALEDIR = /home/postgres/bin/pgsql/15/share/locale
MANDIR = /home/postgres/bin/pgsql/15/share/man
SHAREDIR = /home/postgres/bin/pgsql/15/share
SYSCONFDIR = /home/postgres/bin/pgsql/15/etc
PGXS = /home/postgres/bin/pgsql/15/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE =  '--prefix=/home/postgres/bin/pgsql/15'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -O2
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/home/postgres/bin/pgsql/15/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lz -lreadline -lpthread -lrt -ldl -lm
VERSION = PostgreSQL 15.0
[postgres@postgres ~]$ cd /home/postgres/bin/pgsql/15/lib
[postgres@postgres lib]$ ls
cyrillic_and_mic.so    libecpg.a               libpgcommon_shlib.a  libpq.so                    plpgsql.so            utf8_and_gb18030.so
dict_snowball.so       libecpg_compat.a        libpgfeutils.a       libpq.so.5                  repmgr.so             utf8_and_gbk.so
euc2004_sjis2004.so    libecpg_compat.so       libpgport.a          libpq.so.5.15               utf8_and_big5.so      utf8_and_iso8859_1.so
euc_cn_and_mic.so      libecpg_compat.so.3     libpgport_shlib.a    libpqwalreceiver.so         utf8_and_cyrillic.so  utf8_and_iso8859.so
euc_jp_and_sjis.so     libecpg_compat.so.3.15  libpgtypes.a         pgoutput.so                 utf8_and_euc2004.so   utf8_and_johab.so
euc_kr_and_mic.so      libecpg.so              libpgtypes.so        pg_stat_statements.control  utf8_and_euc_cn.so    utf8_and_sjis2004.so
euc_tw_and_big5.so     libecpg.so.6            libpgtypes.so.3      pg_stat_statements.so       utf8_and_euc_jp.so    utf8_and_sjis.so
latin2_and_win1250.so  libecpg.so.6.15         libpgtypes.so.3.15   pgxs                        utf8_and_euc_kr.so    utf8_and_uhc.so
latin_and_mic.so       libpgcommon.a           libpq.a              pkgconfig                   utf8_and_euc_tw.so    utf8_and_win.so
[postgres@postgres lib]$ psqll
bash: psqll: command not found...
Similar command is: 'psql'
[postgres@postgres lib]$ psql
psql (15.7, server 15.0)
Type "help" for help.

postgres=#

--

Thanks & Regards,

BHAVANI DHULIPALLA

(973)-615-0290