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(at)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(dot)klaver(at)aklaver(dot)com