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

On Tue, May 4, 2021 at 10:04 PM Ian Lawrence Barwick <barwick@gmail.com>
wrote:

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

Thanks Ian for your help! I was able to create the extensions.