Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMbyt-003Ke6-5i for pgsql-general@arkaria.postgresql.org; Wed, 26 Jun 2024 23:23:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sMbyr-006zGQ-Fk for pgsql-general@arkaria.postgresql.org; Wed, 26 Jun 2024 23:23:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMbyr-006zGI-0j for pgsql-general@lists.postgresql.org; Wed, 26 Jun 2024 23:23:13 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sMbyo-003IZB-5m for pgsql-general@lists.postgresql.org; Wed, 26 Jun 2024 23:23:12 +0000 Received: by mail-pj1-x102a.google.com with SMTP id 98e67ed59e1d1-2c8dccd0fa9so929137a91.2 for ; Wed, 26 Jun 2024 16:23:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719444189; x=1720048989; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=768YYev+/9VrZY8JUXGyTiTxbG++DqPbB1wdOrjiVWQ=; b=cN6mYs5fAM7YhzI4bOTV6MjbZVglVbrMRH92mCNfD36iX7dBCjLRNaQZ/jWjI/FhMH uNGAjIQEZNo47LWzRj+pJ0qYgwpxir3bAW5fCqJX0x+UP4I2sxkdHeZmwiAEMgqkB1JJ jMuO7iEIRzcq40GtIDgd+KCDCLNjcPtnihi8NUfefqaXlPb5Jw10fQS+qz8qJI1FZwJT FHZXCYQa1DZsIj9HrB5Kc4rNs4PK327PoQfjQ2Si1hl83/VrgwLsrw2pJEvnG+Vot0C0 jTvi1dXVGBnZXleMu4PRL90G/YoUv3nm9y8r0ih4YrXDMDf6b2w+3upSrgz/IlmvPKi1 IqaQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719444189; x=1720048989; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=768YYev+/9VrZY8JUXGyTiTxbG++DqPbB1wdOrjiVWQ=; b=KcAuRLCsSMrtb1idC2/P2jZr61IQM3ST5WhngzwYg9sIxOtkAIFrKQOt/cKudpwD83 /wc8VellB0yAoQeva7qKY86wwI5Hzzjay+QQMYs3AtU9BNq6xoErrdQD/UYRL12CfHku uRL1ek0xqQ/CbJuzYa0vBVM8SgaEkVHGjgCevQhyMeWm783a8dNXVtnA6ZbAdEdHTVHl 7IhaQkar4uSc+QsuOj2IJ5SEhYryqOoZ/ylPCCYaxl41E/uGzJPc5xzPo3Rpc6rsnrHV DIsJfHW53tD5Yx2eB7zSqE4PHXb8jkjFM0tXamJBqSD3yCQDgSIrz/god7SeXmD6Vtr6 D/UQ== X-Gm-Message-State: AOJu0Yx46jLX2ld4FCtY0zcNfTcfyi5+2aJ9GL+gqsimnvzlNaE+Zwlm nX5wtaIZhaXzhRva43HX7b7YBKzKij+boRhlQwmtBIkwu6szpInpKiykJ8W0JNh6+ombtid4vpY 0Wxk0CXs/hcWeZGUnaLOlS2f2Sh7TE+fw X-Google-Smtp-Source: AGHT+IHtP4a4SPai29g9hk6YP2vRa+tvWCKob6DGngtNqWwsn17elzUnH7r6PzrqDpwk9gbW2s1pFxaL6644R/cR6gE= X-Received: by 2002:a17:90a:780f:b0:2c2:f704:5278 with SMTP id 98e67ed59e1d1-2c8ab7379d4mr6523096a91.42.1719444188702; Wed, 26 Jun 2024 16:23:08 -0700 (PDT) MIME-Version: 1.0 From: bhavani dba Date: Wed, 26 Jun 2024 19:22:57 -0400 Message-ID: Subject: Issue with installing postgres extension To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000143321061bd34c50" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000143321061bd34c50 Content-Type: text/plain; charset="UTF-8" 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 --000000000000143321061bd34c50 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I am having issues with postgres extensions and I have alr= eady installed the contrib package.

thank you=C2=A0for t= he help!!

postgres=3D# CREATE EXTENSION pg_stat_stat= ements;
ERROR: =C2=A0could not load library "/home/postgres/bin/pgs= ql/15/lib/pg_stat_statements.so": /home/postgres/bin/pgsql/15/lib/pg_s= tat_statements.so: undefined symbol: InitMaterializedSRF
postgres=3D#postgres=3D# exit
[postgres@postgres ~]$ rpm -q postgresql15-contribpostgresql15-contrib-15.7-3PGDG.rhel8.x86_64
[postgres@postgres ~]$ pg_= config
BINDIR =3D /home/postgres/bin/pgsql/15/bin
DOCDIR =3D /home/po= stgres/bin/pgsql/15/share/doc
HTMLDIR =3D /home/postgres/bin/pgsql/15/sh= are/doc
INCLUDEDIR =3D /home/postgres/bin/pgsql/15/include
PKGINCLUDE= DIR =3D /home/postgres/bin/pgsql/15/include
INCLUDEDIR-SERVER =3D /home/= postgres/bin/pgsql/15/include/server
LIBDIR =3D /home/postgres/bin/pgsql= /15/lib
PKGLIBDIR =3D /home/postgres/bin/pgsql/15/lib
LOCALEDIR =3D /= home/postgres/bin/pgsql/15/share/locale
MANDIR =3D /home/postgres/bin/pg= sql/15/share/man
SHAREDIR =3D /home/postgres/bin/pgsql/15/share
SYSCO= NFDIR =3D /home/postgres/bin/pgsql/15/etc
PGXS =3D /home/postgres/bin/pg= sql/15/lib/pgxs/src/makefiles/pgxs.mk
CON= FIGURE =3D =C2=A0'--prefix=3D/home/postgres/bin/pgsql/15'
CC =3D= gcc
CPPFLAGS =3D -D_GNU_SOURCE
CFLAGS =3D -Wall -Wmissing-prototypes= -Wpointer-arith -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels= -Wmissing-format-attribute -Wimplicit-fallthrough=3D3 -Wcast-function-type= -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstanda= rd -Wno-format-truncation -Wno-stringop-truncation -O2
CFLAGS_SL =3D -fP= IC
LDFLAGS =3D -Wl,--as-needed -Wl,-rpath,'/home/postgres/bin/pgsql/= 15/lib',--enable-new-dtags
LDFLAGS_EX =3D
LDFLAGS_SL =3D
LIBS = =3D -lpgcommon -lpgport -lz -lreadline -lpthread -lrt -ldl -lm
VERSION = =3D PostgreSQL 15.0
[postgres@postgres ~]$ cd /home/postgres/bin/pgsql/1= 5/lib
[postgres@postgres lib]$ ls
cyrillic_and_mic.so =C2=A0 =C2=A0li= becpg.a =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 libpgcommon_shlib.= a =C2=A0libpq.so =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0plpgsql.so =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0utf8_and_g= b18030.so
dict_snowball.so =C2=A0 =C2=A0 =C2=A0 libecpg_compat.a =C2=A0 = =C2=A0 =C2=A0 =C2=A0libpgfeutils.a =C2=A0 =C2=A0 =C2=A0 libpq.so.5 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0repmgr.so =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 utf8_and_gbk.so
euc2004_sjis2004.so =C2= =A0 =C2=A0libecpg_compat.so =C2=A0 =C2=A0 =C2=A0 libpgport.a =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0libpq.so.5.15 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 utf8_and_big5.so =C2=A0 =C2=A0 =C2=A0utf8_and_iso8859_1.so
euc_c= n_and_mic.so =C2=A0 =C2=A0 =C2=A0libecpg_compat.so.3 =C2=A0 =C2=A0 libpgpor= t_shlib.a =C2=A0 =C2=A0libpqwalreceiver.so =C2=A0 =C2=A0 =C2=A0 =C2=A0 utf8= _and_cyrillic.so =C2=A0utf8_and_iso8859.so
euc_jp_and_sjis.so =C2=A0 =C2= =A0 libecpg_compat.so.3.15 =C2=A0libpgtypes.a =C2=A0 =C2=A0 =C2=A0 =C2=A0 p= goutput.so =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 utf8_and= _euc2004.so =C2=A0 utf8_and_johab.so
euc_kr_and_mic.so =C2=A0 =C2=A0 =C2= =A0libecpg.so =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0libpgtypes.so= =C2=A0 =C2=A0 =C2=A0 =C2=A0pg_stat_statements.control =C2=A0utf8_and_euc_c= n.so =C2=A0 =C2=A0utf8_and_sjis2004.so
euc_tw_and_big5.so =C2=A0 =C2=A0 = libecpg.so.6 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0libpgtypes.so.3 =C2= =A0 =C2=A0 =C2=A0pg_stat_statements.so =C2=A0 =C2=A0 =C2=A0 utf8_and_euc_jp= .so =C2=A0 =C2=A0utf8_and_sjis.so
latin2_and_win1250.so =C2=A0libecpg.so= .6.15 =C2=A0 =C2=A0 =C2=A0 =C2=A0 libpgtypes.so.3.15 =C2=A0 pgxs =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0ut= f8_and_euc_kr.so =C2=A0 =C2=A0utf8_and_uhc.so
latin_and_mic.so =C2=A0 = =C2=A0 =C2=A0 libpgcommon.a =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 libpq.a =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0pkgconfig =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 utf8_and_euc_tw.so =C2=A0 =C2=A0= utf8_and_win.so
[postgres@postgres lib]$ psqll
bash: psqll: command n= ot found...
Similar command is: 'psql'
[postgres@postgres lib= ]$ psql
psql (15.7, server 15.0)
Type "help" for help.
<= br>postgres=3D#



--
Thank= s & Regards,

BHAVANI = DHULIPALLA
(973)-615-0290
--000000000000143321061bd34c50--