Re: CREATE EXTENSION to load the language into the database

On 5/3/19 8:56 AM, Daulat Ram wrote:
> Hello team,
>
> We are getting below issue while creating a function in Potsgres 11.2
>
> nagios=# create or replace function diskf (filesystem text, warn int,
> err int) returns text as $BODY$
>
> nagios$# use warnings;
>
> nagios$# use strict;
>
> nagios$# my $fs = $_[0];
>
> nagios$# my $w = $_[1];
>
> nagios$# my $e = $_[2];
>
> nagios$# my $r = "WARNING";
>
> nagios$# my $output = `df -kP $fs`;
>
> nagios$# $output =~ /.*\s+(\d+)%.*/;
>
> nagios$# $output = $1;
>
> nagios$# if ($output > $w)
>
> nagios$# { $r = "ERROR" if $output > $e;}
>
> nagios$# else { $r = "OK";}
>
> nagios$# return  "$r $output";
>
> nagios$# $BODY$ language plperlu;
>
> ERROR:  language "plperlu" does not exist
>
> HINT:  Use CREATE EXTENSION to load the language into the database.
>
> nagios=# SELECT * FROM pg_language;
>
> lanname  | lanowner | lanispl | lanpltrusted | lanplcallfoid | laninline
> | lanvalidator | lanacl
>
> ----------+----------+---------+--------------+---------------+-----------+--------------+--------
>
> internal |       10 | f       | f            |             0 |         0
> |         2246 |
>
> c        |       10 | f       | f            |             0 |         0
> |         2247 |
>
> sql      |       10 | f       | t            |             0 |         0
> |         2248 |
>
> plpgsql  |       10 | t       | t            |         13075 |     13076
> |        13077 |
>
> (4 rows)
>
> To solve this issue , I am getting the below warnings if creating
> extensions.
>
> nagios=# CREATE EXTENSION plperl;
>
> ERROR:  could not open extension control file
> "/usr/local/share/postgresql/extension/plperl.control": No such file or
> directory
>
> nagios=# CREATE LANGUAGE plperlu;
>
> ERROR:  could not load library "/usr/local/lib/postgresql/plperl.so":
> Error loading shared library libperl.so.5.20: No such file or directory
> (needed by /usr/local/lib/postgresql/plperl.so)
>
> nagios=# CREATE LANGUAGE plperlu;
>
> ERROR:  could not load library "/usr/local/lib/postgresql/plperl.so":
> Error loading shared library libperl.so.5.20: No such file or directory
> (needed by /usr/local/lib/postgresql/plperl.so)

The plperl(u) extension has not been added to the Postgres installation.
You need to do that. To help you with that we need to know:

What OS(and version) are you using?

How did you install Postgres?

>
> nagios=#
>
> Regards,
>
> Dault
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com