public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: bhavani dba <[email protected]>
Cc: [email protected]
Subject: Re: Issue with installing postgres extension
Date: Wed, 26 Jun 2024 19:43:04 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CADNOF=5ycVkV=6APvR+yA+5wzGie-qDA4N5RUkA9msoeoOTPYQ@mail.gmail.com>
References: <CADNOF=5ycVkV=6APvR+yA+5wzGie-qDA4N5RUkA9msoeoOTPYQ@mail.gmail.com>

bhavani dba <[email protected]> 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

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Issue with installing postgres extension
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox