plperl and plperlu language extentsions
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 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_6410.4-1PGDG.rhel7 pgdg10 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
Re: plperl and plperlu language extentsions
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 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_6410.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.kla...@aklaver.com > -- Niles Oien, National Solar Observatory, Boulder Colorado USA
Re: plperl and plperlu language extentsions
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 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 > 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_6410.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.kla...@aklaver.com >> > > > > -- > Niles Oien, National Solar Observatory, Boulder Colorado USA > -- Niles Oien, National Solar Observatory, Boulder Colorado USA
