Re: plctl extension issue postgresql 11.2

Hi Adrian,

Sorry for the late reply please find the below details,

[root(at)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*

On Wed, Mar 27, 2019 at 7:39 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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(at)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
> >
> >
> > --
> >
> >
> > Regards,
> > Prakash.R
> > Postgresql DBA
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--

Regards,
Prakash.R
Postgresql DBA