Re: Error creating postgres extensions

2021年5月5日(水) 10:43 Tiffany Thang <tiffanythang@gmail.com>:
>
> 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"

You need the "postgresql13-contrib" package as well.

> 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?

Normally new extension versions (at least for the core contrib
modules) are provided with
each major version release, so that will be take care of when
performing a major version upgrade.

If you do ever need to update an extension, the process is:
- install new binary
- execute "ALTER EXTENSION UPDATE"
- if the extension provides a shared library, PostgreSQL will need to
be restarted to activate the new library

Regards

Ian Barwick


--
EnterpriseDB: https://www.enterprisedb.com