Re: plperl and plperlu language extentsions
От | Adrian Klaver |
---|---|
Тема | Re: plperl and plperlu language extentsions |
Дата | |
Msg-id | bbfc9564-151a-7375-000d-ec83dcc56b61@aklaver.com обсуждение исходный текст |
Ответ на | plperl and plperlu language extentsions (Niles Oien <noien@nso.edu>) |
Список | 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@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> > <http://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@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
В списке pgsql-general по дате отправления: