Re: plctl extension issue postgresql 11.2 - Mailing list pgsql-general

From Prakash Ramakrishnan
Subject Re: plctl extension issue postgresql 11.2
Date
Msg-id CAA2eZXwFJ6dmhPXwwfeg6RdLu_0XYsAOtzXD7yd+S0aQ7ddgMw@mail.gmail.com
Whole thread Raw
In response to Re: plctl extension issue postgresql 11.2  (Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com>)
Responses Re: plctl extension issue postgresql 11.2
List pgsql-general
Hi Tom,

Thanks for your big help i did yum install plctl and extension below path but still am getting error please find the below details,

==> psql
psql (11.2)
Type "help" for help.

postgres=# \c "AIBE01PR"
You are now connected to database "AIBE01PR" as user "postgres".
AIBE01PR=# create extension plctl;
ERROR:  could not open extension control file "/usr/pgsql-11/share/extension/plctl.control": No such file or directory
AIBE01PR=#
AIBE01PR=# \q
postgres@ brurhenaaa001   .enterprisenet.org:/home/postgres
==> sudo su -
Last login: Thu Mar 28 17:02:53 CET 2019 on pts/0
[root@ brurhenaaa001   ~]# yum list installed | grep -i postgresql
postgresql.x86_64                     9.2.24-1.el7_5         @rhel-7-server-rpms
postgresql-devel.x86_64               9.2.24-1.el7_5         @rhel-7-server-rpms
postgresql-jdbc.noarch                9.2.1002-6.el7_5       @rhel-7-server-rpms
postgresql-libs.x86_64                9.2.24-1.el7_5         @rhel-7-server-rpms
postgresql-odbc.x86_64                09.03.0100-2.el7       @rhel-7-server-rpms
postgresql-pgpool-II.x86_64           3.4.6-1.el7            @tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-devel.x86_64     3.4.6-1.el7            @tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-extensions.x86_64
postgresql-plruby.x86_64              0.5.3-13.el7           @tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-plruby-doc.x86_64          0.5.3-13.el7           @tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pltcl.x86_64               9.2.24-1.el7_5         @rhel-7-server-rpms
postgresql-server.x86_64              9.2.24-1.el7_5         @rhel-7-server-rpms
postgresql11.x86_64                   11.2-2PGDG.rhel7       @pgdg11
postgresql11-contrib.x86_64           11.2-2PGDG.rhel7       @pgdg11
postgresql11-devel.x86_64             11.2-2PGDG.rhel7       @pgdg11
postgresql11-libs.x86_64              11.2-2PGDG.rhel7       @pgdg11
postgresql11-llvmjit.x86_64           11.2-2PGDG.rhel7       @pgdg11
postgresql11-pltcl.x86_64             11.2-2PGDG.rhel7       @pgdg11
postgresql11-server.x86_64            11.2-2PGDG.rhel7       @pgdg11
postgresql11-tcl.x86_64               2.4.0-2.rhel7.1        @pgdg11
[root@brurhenaaa001 ~]# cd /usr/pgsql-11/share/extension
[root@ brurhenaaa001   extension]# ls
adminpack--1.0--1.1.sql             fuzzystrmatch--1.1.sql                oracle_fdw--1.0--1.1.sql                 pg_trgm--1.3--1.4.sql
adminpack--1.0.sql                  fuzzystrmatch.control                 oracle_fdw--1.1.sql                      pg_trgm--1.3.sql
adminpack--1.1--2.0.sql             fuzzystrmatch--unpackaged--1.0.sql    oracle_fdw.control                       pg_trgm.control
adminpack.control                   hstore--1.0--1.1.sql                  pageinspect--1.0--1.1.sql                pg_trgm--unpackaged--1.0.sql
amcheck--1.0--1.1.sql               hstore--1.1--1.2.sql                  pageinspect--1.1--1.2.sql                pg_visibility--1.0--1.1.sql
amcheck--1.0.sql                    hstore--1.2--1.3.sql                  pageinspect--1.2--1.3.sql                pg_visibility--1.1--1.2.sql
amcheck.control                     hstore--1.3--1.4.sql                  pageinspect--1.3--1.4.sql                pg_visibility--1.1.sql
autoinc--1.0.sql                    hstore--1.4--1.5.sql                  pageinspect--1.4--1.5.sql                pg_visibility.control
autoinc.control                     hstore--1.4.sql                       pageinspect--1.5--1.6.sql                plpgsql--1.0.sql
autoinc--unpackaged--1.0.sql        hstore.control                        pageinspect--1.5.sql                     plpgsql.control
bloom--1.0.sql                      hstore_plperl--1.0.sql                pageinspect--1.6--1.7.sql                plpgsql--unpackaged--1.0.sql
bloom.control                       hstore_plperl.control                 pageinspect.control                      pltcl--1.0.sql
btree_gin--1.0--1.1.sql             hstore_plperlu--1.0.sql               pageinspect--unpackaged--1.0.sql         pltcl.control
btree_gin--1.0.sql                  hstore_plperlu.control                pg_buffercache--1.0--1.1.sql             pltclu--1.0.sql


On Thu, Mar 28, 2019 at 9:09 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> wrote:
Thanks, I'll check it out. 

On Thu, Mar 28, 2019, 20:26 Tom Lane <tgl@sss.pgh.pa.us> wrote:
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> Still postgresql11-tcl is a valid package in the PGDG repos(it is for a
> Tcl client library). It is trying to find postgresql11-tcl in the RHEL
> repo not the PGDG repo. Yet packages have been installed from  the PGDG
> repo(from previous post) in the past:

> postgresql11.x86_64                   11.2-1PGDG.rhel7       @pgdg11
> postgresql11-contrib.x86_64           11.2-1PGDG.rhel7       @pgdg11
> postgresql11-devel.x86_64             11.2-1PGDG.rhel7       @pgdg11
> postgresql11-libs.x86_64              11.2-1PGDG.rhel7       @pgdg11
> postgresql11-llvmjit.x86_64           11.2-1PGDG.rhel7       @pgdg11
> postgresql11-server.x86_64            11.2-1PGDG.rhel7       @pgdg11

> You will need to sort out how the above packages where installed and
> replicate that for the pltcl package. I cannot be of more help as I do
> not use RH. Maybe someone else can chime in.

Yeah.  The PGDG package repo is evidently not being searched by yum,
so it's either been removed or disabled in yum's repo configuration
list.  (It must have been there at one time, unless you used a
*really* nonstandard way of installing those RPMs.)

Look into /etc/yum.repos.d/ ... if you see a file for the PGDG repo,
fix it to be enabled, otherwise you need to download and install that
repo config file.

                        regards, tom lane


--


Regards,
Prakash.R
Postgresql DBA

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: stale WAL files?
Next
From: Moreno Andreo
Date:
Subject: Re: Key encryption and relational integrity