Re: plctl extension issue postgresql 11.2

Поиск
Список
Период
Сортировка
От Prakash Ramakrishnan
Тема Re: plctl extension issue postgresql 11.2
Дата
Msg-id CAA2eZXz2846BSx1V7jbv28qpQoX6DGJ__-WgR-Z+_+j2-Wvwkg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plctl extension issue postgresql 11.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi Adrian,

Sorry for the late reply please find the below details,

[root@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.klaver@aklaver.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@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
> --
>
>
> Regards,
> Prakash.R
> Postgresql DBA


--
Adrian Klaver
adrian.klaver@aklaver.com


--


Regards,
Prakash.R
Postgresql DBA

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Data entry / data editing tools (more end-user focus).
Следующее
От: Mike Martin
Дата:
Сообщение: Is it possible to have a cascade upwards query?