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