Search Postgresql Archives

Re: Issue with installing postgres extension

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux