From: Tom Lane <tgl@sss.pgh.pa.us>
To: bhavani dba <dbabhavani@gmail.com>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Issue with installing postgres extension
In-reply-to: <CADNOF=5ycVkV=6APvR+yA+5wzGie-qDA4N5RUkA9msoeoOTPYQ@mail.gmail.com>
References: <CADNOF=5ycVkV=6APvR+yA+5wzGie-qDA4N5RUkA9msoeoOTPYQ@mail.gmail.com>
Comments: In-reply-to bhavani dba <dbabhavani@gmail.com>
	message dated "Wed, 26 Jun 2024 19:22:57 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1639898.1719445384.1@sss.pgh.pa.us>
Date: Wed, 26 Jun 2024 19:43:04 -0400
Message-ID: <1639899.1719445384@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1639899.1719445384%40sss.pgh.pa.us>
Precedence: bulk

bhavani dba <dbabhavani@gmail.com> writes:
> 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

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