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