On Tue, May 4, 2021 at 10:04 PM Ian Lawrence Barwick <barw...@gmail.com> wrote:
> 2021年5月5日(水) 10:43 Tiffany Thang <tiffanyth...@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.