I got it working, although I found it a bit odd. Although "yum list" showed postgresql10-plperl.x86_64 as being installed, in fact :
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@xxxxxxx> 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@xxxxxxxxxxx> 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@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@xxxxxxxxxxx
--Niles Oien, National Solar Observatory, Boulder Colorado USA
Niles Oien, National Solar Observatory, Boulder Colorado USA
