Re: Error creating postgres extensions

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

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