From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Niles Oien <noien(at)nso(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: plperl and plperlu language extentsions |
Date: | 2018-06-28 20:16:39 |
Message-ID: | bbfc9564-151a-7375-000d-ec83dcc56b61@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)nso(dot)edu
> <mailto:noien(at)nso(dot)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(dot)klaver(at)aklaver(dot)com <mailto: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>
> <http://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 <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
>
> --
> Niles Oien, National Solar Observatory, Boulder Colorado USA
>
>
>
>
> --
> Niles Oien, National Solar Observatory, Boulder Colorado USA
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2018-06-28 21:17:44 | Re: Analyze plan of foreign data wrapper |
Previous Message | Niles Oien | 2018-06-28 19:21:14 | Re: plperl and plperlu language extentsions |