Thread: plperl and plperlu language extentsions

On Thu, Jun 28, 2018 at 9:26 AM Niles Oien <noien@nso.edu> wrote:
>
> Yet plperl would seem to be installed :
>
> # yum list | grep postgres | grep perl
> postgresql-plperl.x86_64                  9.2.23-3.el7_4               base
> postgresql10-plperl.x86_64                10.4-1PGDG.rhel7             pgdg10
>

Reinstalling the package?
Is the correct package for the 10 distribution?

Luca

On 06/27/2018 08:27 AM, Niles Oien wrote:
> 
> Hi,
> 
> I am running postgres 10.4 on CentOS 7.5. I am having trouble getting 
> the plperl language extension going :
> 
> netdrms02.nispdc.nso.edu:5432 <http://netdrms02.nispdc.nso.edu:5432> 
> postgres@nsocu=# CREATE EXTENSION plperl;
> ERROR:  58P01: could not open extension control file 
> "/usr/pgsql-10/share/extension/plperl.control": No such file or directory
> LOCATION:  parse_extension_control_file, extension.c:494
> 
> Sure enough that file is not there :
> 
> [production@netdrms02 ~]$ ls /usr/pgsql-10/share/extension/
> plpgsql--1.0.sql  plpgsql.control  plpgsql--unpackaged--1.0.sql
> 
> 
> Yet plperl would seem to be installed :
> 
> # yum list | grep postgres | grep perl
> postgresql-plperl.x86_64                  9.2.23-3.el7_4               base
> postgresql10-plperl.x86_64                10.4-1PGDG.rhel7            
>   pgdg10

So where did you get the packages to install Postgres itself?:

a) The CentOsS repos

b) The PGDG repos

> 
> I need to do this for both plperl and plperlu. I think there is perhaps 
> something I don't have installed, but I can't tell what? I apologize if 
> this is obvious, the language extensions are not something I deal with 
> regularly.
> 
> If it helps, here is the result of "select version();" :
> PostgreSQL 10.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 
> 20150623 (Red Hat 4.8.5-28), 64-bit
> 
> Thanks for considering this,
> 
> Niles.
> 
> 
> -- 
> Niles Oien, National Solar Observatory, Boulder Colorado USA


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 06/28/2018 12:21 PM, Niles Oien wrote:
> 
> I got it working, although I found it a bit odd. Although "yum list" 
> showed postgresql10-plperl.x86_64 as being installed, in fact :

I don't use RH based systems much so I failed to catch it earlier. From 
your earlier post:

# yum list | grep postgres | grep perl
postgresql-plperl.x86_64                  9.2.23-3.el7_4 
base
postgresql10-plperl.x86_64                10.4-1PGDG.rhel7 
pgdg10


http://yum.baseurl.org/wiki/YumCommands

"   yum list

     By default 'yum list' without any options will list all packages in 
all the repositories and all the packages installed on your system. 
Note: 'yum list all' and 'yum list' give the same output.
"

So you where seeing packages in the repo's that where not installed yet 
as well as any that where installed.

If I am following you need to use:

yum list installed

to see only installed packages.

> 
> yum install postgresql10-plperl
> 
> went ahead as if it was not installed, and I was now able to create the 
> language extensions.
> 
> Thanks, all,
> 
> Niles.
> 
> 
> On Thu, Jun 28, 2018 at 8:42 AM, Niles Oien <noien@nso.edu 
> <mailto:noien@nso.edu>> wrote:
> 
> 
> 
>     Thanks for responding!
> 
>     I installed Postgres 10 from the PG repos. I believe the system came
>     with Postgres 9.2 on it but I never used that. Postgres 10 is first
>     in the path.
> 
> 
> 
>     On Thu, Jun 28, 2018 at 7:03 AM, Adrian Klaver
>     <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>         On 06/27/2018 08:27 AM, Niles Oien wrote:
> 
> 
>             Hi,
> 
>             I am running postgres 10.4 on CentOS 7.5. I am having
>             trouble getting the plperl language extension going :
> 
>             netdrms02.nispdc.nso.edu:5432
>             <http://netdrms02.nispdc.nso.edu:5432>
>             <http://netdrms02.nispdc.nso.edu:5432
>             <http://netdrms02.nispdc.nso.edu:5432>> postgres@nsocu=#
>             CREATE EXTENSION plperl;
>             ERROR:  58P01: could not open extension control file
>             "/usr/pgsql-10/share/extension/plperl.control": No such file
>             or directory
>             LOCATION:  parse_extension_control_file, extension.c:494
> 
>             Sure enough that file is not there :
> 
>             [production@netdrms02 ~]$ ls /usr/pgsql-10/share/extension/
>             plpgsql--1.0.sql  plpgsql.control  plpgsql--unpackaged--1.0.sql
> 
> 
>             Yet plperl would seem to be installed :
> 
>             # yum list | grep postgres | grep perl
>             postgresql-plperl.x86_64                  9.2.23-3.el7_4   
>                         base
>             postgresql10-plperl.x86_64                10.4-1PGDG.rhel7 
>                          pgdg10
> 
> 
>         So where did you get the packages to install Postgres itself?:
> 
>         a) The CentOsS repos
> 
>         b) The PGDG repos
> 
> 
> 
>             I need to do this for both plperl and plperlu. I think there
>             is perhaps something I don't have installed, but I can't
>             tell what? I apologize if this is obvious, the language
>             extensions are not something I deal with regularly.
> 
>             If it helps, here is the result of "select version();" :
>             PostgreSQL 10.4 on x86_64-pc-linux-gnu, compiled by gcc
>             (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
> 
>             Thanks for considering this,
> 
>             Niles.
> 
> 
>             -- 
>             Niles Oien, National Solar Observatory, Boulder Colorado USA
> 
> 
> 
>         -- 
>         Adrian Klaver
>         adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> 
> 
>     -- 
>     Niles Oien, National Solar Observatory, Boulder Colorado USA
> 
> 
> 
> 
> -- 
> Niles Oien, National Solar Observatory, Boulder Colorado USA


-- 
Adrian Klaver
adrian.klaver@aklaver.com