Обсуждение: Re: plctl extension issue postgresql 11.2

On 3/27/19 2:46 AM, Prakash Ramakrishnan wrote:
> Hi Adrian,
> 
> Sorry for late reply am try to install the plctl but still getting error.

 From looks of it you did not do the original install of Postgres from 
the PGDG repos. The first thing you need to figure out is where you 
installed Postgres from? I am not a RH  user, but I believe the below 
might help:

yum list installed | grep -i postgresql

> 
> [root@brurhenaaa001 postgres]# rpm -ivh 
> postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64.rpm
> error: Failed dependencies:
>          postgresql11(x86-64) = 11.2-2PGDG.rhel7 is needed by 
> postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
>          postgresql11-server(x86-64) = 11.2-2PGDG.rhel7 is needed by 
> postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
> [root@ brurhenaaa001   postgres]#
> [root@ brurhenaaa001   postgres]#
> 
> 
> On Tue, Mar 26, 2019 at 11:26 PM Adrian Klaver 
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 3/26/19 10:43 AM, Prakash Ramakrishnan wrote:
>      > I did postgres 11.2 version using yum option this file only
>     Missing and
>      > using rhel 7.5 version.
>      >
> 
>     If you are using the PGDG repos then it looks like you need:
> 
>     https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/letter_p.group.html
> 
>     postgresql11-pltcl
> 
>     Not sure if that would also work for the RH repos.
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> 
> -- 
> 
> 
> Regards,
> Prakash.R
> Postgresql DBA


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 3/27/19 8:32 AM, Prakash Ramakrishnan wrote:
> Hi Adrian,
> 
> Sorry for the late reply please find the below details,

Again I am not a RH user so take the following with that in mind.

What if you do?:

sudo yum install postgresql11-tcl

> 
> [root@brurhenaaa001 postgres]# 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-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*
> 
> 
>

-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 3/28/19 3:20 AM, Prakash Ramakrishnan wrote:
> Hi Adrian,
> 
> I tried which command you gave but its not working.please check,

First I posted the wrong package name previously. For the Tcl PL it 
should be:

postgresql11-pltcl

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.

> 
> [root@brurhenaaa001 postgres]# yum install postgresql11-tcl
> Loaded plugins: enabled_repos_upload, langpacks, package_upload, 
> product-id, search-disabled-repos, subscription-manager
> rhel-7-server-eus-optional-rpms                                          
>                                                               | 2.0 kB  
> 00:00:00
> rhel-7-server-eus-satellite-tools-6.2-rpms                              
>                                                                | 2.1 kB  
> 00:00:00
> rhel-7-server-extras-rpms                                                
>                                                               | 2.0 kB  
> 00:00:00
> rhel-7-server-rpms                                                      
>                                                                | 2.0 kB  
> 00:00:00
> rhel-7-server-satellite-tools-6.2-rpms                                  
>                                                                | 2.1 kB  
> 00:00:00
> rhel-server-rhscl-7-eus-rpms                                            
>                                                                | 2.0 kB  
> 00:00:00
> tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7  
>                                                       | 2.1 kB  00:00:00
> No package postgresql11-tcl available.
> Error: Nothing to do
> Uploading Enabled Repositories Report
> Loaded plugins: langpacks, product-id, subscription-manager
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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

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