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(at)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(dot)ramakrishnan(dot)ap(at)nielsen(dot)com
> <mailto:prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com>> wrote:
>
> Thanks, I'll check it out.
>
> On Thu, Mar 28, 2019, 20:26 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> wrote:
>
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com