Re: Issue with installing postgres extension

[bhavani dba <dbabhavani@xxxxxxxxx>]

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=#

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=# 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 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

bhavani dba <dbabhavani@xxxxxxxxx> 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

--

Thanks & Regards,

BHAVANI DHULIPALLA

(973)-615-0290