Issue with installing postgres extension

From: bhavani dba <dbabhavani(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Issue with installing postgres extension
Date: 2024-06-26 23:22:57
Message-ID: CADNOF=5ycVkV=6APvR+yA+5wzGie-qDA4N5RUkA9msoeoOTPYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgres ~]$ rpm -q postgresql15-contrib
postgresql15-contrib-15.7-3PGDG.rhel8.x86_64
[postgres(at)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(at)postgres ~]$ cd /home/postgres/bin/pgsql/15/lib
[postgres(at)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(at)postgres lib]$ psqll
bash: psqll: command not found...
Similar command is: 'psql'
[postgres(at)postgres lib]$ psql
psql (15.7, server 15.0)
Type "help" for help.

postgres=#

--
Thanks & Regards,

BHAVANI DHULIPALLA
(973)-615-0290

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-06-26 23:43:04 Re: Issue with installing postgres extension
Previous Message Adrian Klaver 2024-06-26 22:33:27 Re: [External] Dropping connections