Re: Issue with installing postgres extension

2024-06-26 Thread bhavani dba
thank you Tom!!!, I installed postgres 16 and was able to get the extension installed. On Wed, Jun 26, 2024 at 10:46 PM bhavani dba wrote: > Thank you , installing postgres16 on my server. > > Thanks, > Bhavani > > On Wed, Jun 26, 2024 at 10:25 PM Tom Lane wrote: > >> bhavani dba writes: >> >

Re: Issue with installing postgres extension

2024-06-26 Thread bhavani dba
Thank you , installing postgres16 on my server. Thanks, Bhavani On Wed, Jun 26, 2024 at 10:25 PM Tom Lane wrote: > bhavani dba writes: > > 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. > > >

Re: Issue with installing postgres extension

2024-06-26 Thread Tom Lane
bhavani dba writes: > 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. > [postgres@postgres ~]$ psql > psql (15.7, server 15.0) > Type "help" for help. Hmm ... after poking around a bit, it appears y

Re: Issue with installing postgres extension

2024-06-26 Thread bhavani dba
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;

Re: Issue with installing postgres extension

2024-06-26 Thread Tom Lane
bhavani dba 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 tryi

Issue with installing postgres extension

2024-06-26 Thread bhavani dba
I am having issues with postgres extensions and I have already installed the contrib package. thank you for the help!! 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_st