Cannot install Extention plperl in 9.5

On 02/06/2016 02:21 PM, Alex Magnum wrote:

Hi,
I installed 9.5 as described in
http://tecadmin.net/install-postgresql-9-5-on-centos/ on centos7.

Is there a problem with the Repo or do I miss something?

[local]:template1=# \dx
List of installed extensions
Name | Version | Schema | Description
---------------+---------+------------+--------------------------------------------------------------
cube | 1.0 | public | data type for multidimensional
cubes
dblink | 1.1 | public | connect to other PostgreSQL
databases from within a database
earthdistance | 1.0 | public | calculate great-circle
distances on the surface of the Earth
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(4 rows)

[local]:template1=# *CREATE EXTENSION plperl;*
ERROR: could not open extension control file
"/usr/pgsql-9.5/share/extension/plperl.control": No such file or directory

[root@localhost 06:14:37 extension]# *find /usr/pgsql-9.5/|grep perl*
/usr/pgsql-9.5/lib/hstore_plperl.so
/usr/pgsql-9.5/include/server/lib/hyperloglog.h
/usr/pgsql-9.5/include/server/plperl.h
/usr/pgsql-9.5/share/extension/hstore_plperl.control
/usr/pgsql-9.5/share/extension/hstore_plperlu--1.0.sql
/usr/pgsql-9.5/share/extension/hstore_plperlu.control
/usr/pgsql-9.5/share/extension/hstore_plperl--1.0.sql

Thanks for any advice

See here:

http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/repoview/

Looks like you have not installed:

postgresql95-plperl

Alex

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general