Re: plctl extension issue postgresql 11.2

On 3/28/19 9:07 AM, Prakash Ramakrishnan wrote:
> 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*

Try:
create extension pltcl;

> *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 
> <mailto: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
>     <mailto:tgl@sss.pgh.pa.us>> wrote:
> 
>         Adrian Klaver <adrian.klaver@aklaver.com
>         <mailto: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


-- 
Adrian Klaver
adrian.klaver@aklaver.com