From: | Niles Oien <noien(at)nso(dot)edu> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: plperl and plperlu language extentsions |
Date: | 2018-06-28 14:42:15 |
Message-ID: | CANQ3m6NqN_Mu7J7ARAjhVH9dbJnZ+LW0rt5p5=hZWZK+_DBN+Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)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>
>> postgres(at)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(at)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(dot)klaver(at)aklaver(dot)com
>
--
Niles Oien, National Solar Observatory, Boulder Colorado USA
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2018-06-28 14:54:46 | Re: Sv: Re: Sv: Re: CTE optimization fence |
Previous Message | Adrian Klaver | 2018-06-28 13:03:51 | Re: plperl and plperlu language extentsions |