Error creating postgres extensions

From: Tiffany Thang <tiffanythang(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Error creating postgres extensions
Date: 2021-05-05 01:42:57
Message-ID: CAB_W-NPEw2sCpyD5JaiK7reJWZHZoRh8T2BdW8N+-p4nVfvxrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm having trouble finding in the documentation the steps to install the
postgres extensions such as pg_stat_statements and pg_trgm on
PG13.1/CentOS7. Can someone please assist?

postgres=# create extension pg_stat_statements;

ERROR: could not open extension control file
"/usr/pgsql-13/share/extension/pg_stat_statements.control": No such file or
directory

postgres=# create extension pg_trgm;

ERROR: could not open extension control file
"/usr/pgsql-13/share/extension/pg_trgm.control": No such file or directory

I installed PG13 via the YUM repository
https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-7-x86_64 and
then

I ran "yum install postgresql13 postgresql13-server"

Also, what are the steps to update these extensions in the future when
newer releases are made available. For example, updating

pg_stat_statements from 1.7 to 1.8?

Thanks.

Tiff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2021-05-05 02:04:38 Re: Error creating postgres extensions
Previous Message Bruce Momjian 2021-05-04 23:22:12 Re: Postgres upgrade 12 - issues with OIDs