MIME-Version: 1.0
References: <CADNOF=5ycVkV=6APvR+yA+5wzGie-qDA4N5RUkA9msoeoOTPYQ@mail.gmail.com>
 <1639899.1719445384@sss.pgh.pa.us>
In-Reply-To: <1639899.1719445384@sss.pgh.pa.us>
From: bhavani dba <dbabhavani@gmail.com>
Date: Wed, 26 Jun 2024 21:08:23 -0400
Message-ID: <CADNOF=7HFvY_sASN1am0oXkpQLYuwQcPLVPz2vmBk3Yd98cyrQ@mail.gmail.com>
Subject: Re: Issue with installing postgres extension
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000229ab3061bd4c568"
Archived-At: <https://www.postgresql.org/message-id/CADNOF%3D7HFvY_sASN1am0oXkpQLYuwQcPLVPz2vmBk3Yd98cyrQ%40mail.gmail.com>
Precedence: bulk

--000000000000229ab3061bd4c568
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

thank you for tom for your response. i dont remember installing postgres 14
version on the server and it seems like I have postgres 15 running.

Please see below.

[postgres@postgres ~]$ psql
psql (15.7, server 15.0)
Type "help" for help.

postgres=3D#

postgres=3D# 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=3D#
postgres=3D# SELECT version();
                                                  version
---------------------------------------------------------------------------=
---------------------------------
 PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1
20191121 (Red Hat 8.3.1-5.0.1), 64-bit
(1 row)


On Wed, Jun 26, 2024 at 7:43=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> bhavani dba <dbabhavani@gmail.com> writes:
> > postgres=3D# 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
>
> This certainly looks like you are trying to load a v15 extension
> into a pre-v15 server (since the InitMaterializedSRF function
> didn't exist in prior versions).
>
> I'm going to go out on a limb and guess that you just installed
> v15 and forgot to restart the server, so that what's running is
> still v14 or before.  If so, you probably also forgot the
> pg_upgrade step --- you can't simply start a new major version
> in an old one's data directory.
>
>                         regards, tom lane
>


--=20
Thanks & Regards,

BHAVANI DHULIPALLA
(973)-615-0290

--000000000000229ab3061bd4c568
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">thank you for tom for your response. i dont remember insta=
lling postgres 14 version on the=C2=A0server=C2=A0and it seems like I have=
=C2=A0postgres 15 running.<div><br></div><div>Please see below.</div><div><=
br></div><div>[postgres@postgres ~]$ psql<br>psql (15.7, server 15.0)<br>Ty=
pe &quot;help&quot; for help.<br><br>postgres=3D#<br></div><div><br></div><=
div>postgres=3D# CREATE EXTENSION pg_stat_statements;<br>ERROR: =C2=A0could=
 not load library &quot;/home/postgres/bin/pgsql/15/lib/pg_stat_statements.=
so&quot;: /home/postgres/bin/pgsql/15/lib/pg_stat_statements.so: undefined =
symbol: InitMaterializedSRF<br>postgres=3D#<br>postgres=3D# SELECT version(=
);<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 version<br>--------------------------------=
---------------------------------------------------------------------------=
-<br>=C2=A0PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.=
3.1 20191121 (Red Hat 8.3.1-5.0.1), 64-bit<br>(1 row)<br></div><div><br></d=
iv></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_att=
r">On Wed, Jun 26, 2024 at 7:43=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:t=
gl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;=
border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex=
">bhavani dba &lt;<a href=3D"mailto:dbabhavani@gmail.com" target=3D"_blank"=
>dbabhavani@gmail.com</a>&gt; writes:<br>
&gt; postgres=3D# CREATE EXTENSION pg_stat_statements;<br>
&gt; ERROR:=C2=A0 could not load library<br>
&gt; &quot;/home/postgres/bin/pgsql/15/lib/pg_stat_statements.so&quot;:<br>
&gt; /home/postgres/bin/pgsql/15/lib/pg_stat_statements.so: undefined symbo=
l:<br>
&gt; InitMaterializedSRF<br>
<br>
This certainly looks like you are trying to load a v15 extension<br>
into a pre-v15 server (since the InitMaterializedSRF function<br>
didn&#39;t exist in prior versions).<br>
<br>
I&#39;m going to go out on a limb and guess that you just installed<br>
v15 and forgot to restart the server, so that what&#39;s running is<br>
still v14 or before.=C2=A0 If so, you probably also forgot the<br>
pg_upgrade step --- you can&#39;t simply start a new major version<br>
in an old one&#39;s data directory.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Thanks &amp; Regards,<div><br></div><div><div style=3D"font-=
size:small">BHAVANI DHULIPALLA</div><div style=3D"font-size:small">(973)-61=
5-0290</div></div></div></div>

--000000000000229ab3061bd4c568--