Issue with installing postgres extension - Mailing list pgsql-general
From | bhavani dba |
---|---|
Subject | Issue with installing postgres extension |
Date | |
Msg-id | CADNOF=5ycVkV=6APvR+yA+5wzGie-qDA4N5RUkA9msoeoOTPYQ@mail.gmail.com Whole thread Raw |
Responses |
Re: Issue with installing postgres extension
|
List | 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@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=#
--
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
pgsql-general by date: