Hi Adrian, Please find the requested details. What OS(and version) are you using? Ans: bash-4.4$ cat /etc/os-release NAME="Alpine Linux" ID=alpine VERSION_ID=3.9.2 PRETTY_NAME="Alpine Linux v3.9" HOME_URL="https://alpinelinux.org/"; BUG_REPORT_URL="https://bugs.alpinelinux.org/"; bash-4.4$ bash-4.4$ uname -a Linux psql_primary_kbcn 3.10.0-514.16.1.el7.x86_64 #1 SMP Wed Apr 12 15:04:24 UTC 2017 x86_64 Linux bash-4.4$ How did you install Postgres? Ans: We did installation via customized docker image provided by our dev ops team. Regards, Daulat -----Original Message----- From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx> Sent: Friday, May 3, 2019 10:21 PM To: Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx Subject: 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.klaver@xxxxxxxxxxx
