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&gt;
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

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>
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&gt;
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

--
Niles Oien, National Solar Observatory, Boulder Colorado USA

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@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>
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&gt;
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

--
Niles Oien, National Solar Observatory, Boulder Colorado USA

--
Niles Oien, National Solar Observatory, Boulder Colorado USA

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&gt;
<http://netdrms02.nispdc.nso.edu:5432
<http://netdrms02.nispdc.nso.edu:5432&gt;&gt; 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