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@xxxxxxxxxxx> wrote:
Thanks, I'll check it out.On Thu, Mar 28, 2019, 20:26 Tom Lane <tgl@xxxxxxxxxxxxx> wrote:Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
