Re: plctl extension issue postgresql 11.2

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(at)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(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> wrote:

> Thanks, I'll check it out.
>
> On Thu, Mar 28, 2019, 20:26 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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