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