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...@nielsen.com> wrote: > Thanks, I'll check it out. > > On Thu, Mar 28, 2019, 20:26 Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Adrian Klaver <adrian.kla...@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
