Error creating postgres extensions
| От | Tiffany Thang |
|---|---|
| Тема | Error creating postgres extensions |
| Дата | |
| Msg-id | CAB_W-NPEw2sCpyD5JaiK7reJWZHZoRh8T2BdW8N+-p4nVfvxrQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Error creating postgres extensions
|
| Список | 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
В списке pgsql-general по дате отправления: