Thread: BUG #15714: plctl extension issue

BUG #15714: plctl extension issue

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      15714
Logged by:          ramakrishnan r
Email address:      prakash.ramakrishnan.ap@nielsen.com
PostgreSQL version: 11.2
Operating system:   rhel 7.5
Description:

Hi Team,
  
I have done with installation of postgres 11.2 version using yum but am
trying to install the plctl extension am getting error please do the needful
am not able to get the rpm also.

==> psql
psql (11.2)
Type "help" for help.

AIBE01PR=# create extension plctl;
ERROR:  could not open extension control file
"/usr/pgsql-11/share/extension/plctl.control": No such file or directory
AIBE01PR=#


Re: BUG #15714: plctl extension issue

From
Christoph Berg
Date:
Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
> AIBE01PR=# create extension plctl;
> ERROR:  could not open extension control file
> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

The extension is shipped in a separate package that you need to
install on the operating system.

Christoph


Re: BUG #15714: plctl extension issue

From
Prakash Ramakrishnan
Date:
Hi Christoph,

Can you please guide me which file need to be installed I tried not getting solution please do the needful.


Regards,
Prakash.R

On Tue, Mar 26, 2019, 17:38 Christoph Berg <myon@debian.org> wrote:
Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
> AIBE01PR=# create extension plctl;
> ERROR:  could not open extension control file
> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

The extension is shipped in a separate package that you need to
install on the operating system.

Christoph

Re: BUG #15714: plctl extension issue

From
Anthony Sotolongo
Date:

Hi, in Ubuntu the package called postgresql-pltcl-11


sudo apt-get install postgresql-pltcl-11

Regards


El 26-03-19 a las 09:31, Prakash Ramakrishnan escribió:
Hi Christoph,

Can you please guide me which file need to be installed I tried not getting solution please do the needful.


Regards,
Prakash.R

On Tue, Mar 26, 2019, 17:38 Christoph Berg <myon@debian.org> wrote:
Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
> AIBE01PR=# create extension plctl;
> ERROR:  could not open extension control file
> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

The extension is shipped in a separate package that you need to
install on the operating system.

Christoph

Re: BUG #15714: plctl extension issue

From
Tom Lane
Date:
Christoph Berg <myon@debian.org> writes:
> Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
>> AIBE01PR=# create extension plctl;
>> ERROR:  could not open extension control file
>> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

> The extension is shipped in a separate package that you need to
> install on the operating system.

Perhaps even more to the point: the extension is pltcl, not plctl.

(Or at least, I assume you are after the Tcl PL extension.
If there is a "plctl", I haven't heard about it.)

            regards, tom lane


Re: BUG #15714: plctl extension issue

From
Prakash Ramakrishnan
Date:
Hi Tom,

Am using rhel 7.5 can you give some solution.

Regards,
Prakash.R

On Tue, Mar 26, 2019 at 6:52 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Christoph Berg <myon@debian.org> writes:
> Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
>> AIBE01PR=# create extension plctl;
>> ERROR:  could not open extension control file
>> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

> The extension is shipped in a separate package that you need to
> install on the operating system.

Perhaps even more to the point: the extension is pltcl, not plctl.

(Or at least, I assume you are after the Tcl PL extension.
If there is a "plctl", I haven't heard about it.)

                        regards, tom lane


--


Regards,
Prakash.R
Postgresql DBA

Re: BUG #15714: plctl extension issue

From
Prakash Ramakrishnan
Date:
Hi Tom,

I tried before getting this below meassage.

[root@brurhenaaa001 ~]# sudo apt-get install postgresql-pltcl-11
sudo: apt-get: command not found
[root@brurhenppp001 ~]# yum install postgresql-pltcl-11
Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager
rhel-7-server-eus-optional-rpms                                                                                                       | 2.0 kB  00:00:00
rhel-7-server-eus-satellite-tools-6.2-rpms                                                                                            | 2.1 kB  00:00:00
rhel-7-server-extras-rpms                                                                                                             | 2.0 kB  00:00:00
rhel-7-server-rpms                                                                                                                    | 2.0 kB  00:00:00
rhel-7-server-satellite-tools-6.2-rpms                                                                                                | 2.1 kB  00:00:00
rhel-server-rhscl-7-eus-rpms                                                                                                          | 2.0 kB  00:00:00
tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7                                                       | 2.1 kB  00:00:00
No package postgresql-pltcl-11 available.
Error: Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: langpacks, product-id, subscription-manager


On Tue, Mar 26, 2019 at 7:00 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> wrote:
Hi Tom,

Am using rhel 7.5 can you give some solution.

Regards,
Prakash.R

On Tue, Mar 26, 2019 at 6:52 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Christoph Berg <myon@debian.org> writes:
> Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
>> AIBE01PR=# create extension plctl;
>> ERROR:  could not open extension control file
>> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

> The extension is shipped in a separate package that you need to
> install on the operating system.

Perhaps even more to the point: the extension is pltcl, not plctl.

(Or at least, I assume you are after the Tcl PL extension.
If there is a "plctl", I haven't heard about it.)

                        regards, tom lane


--


Regards,
Prakash.R
Postgresql DBA


--


Regards,
Prakash.R
Postgresql DBA

Re: BUG #15714: plctl extension issue

From
Anthony Sotolongo
Date:

Hello, apt-get is a distribution command debian and derivatives
you must search the name of packges in RHEL, try with
yum search pltcl or yum search tcl
 to get the real name in RHEL


regards

El 26-03-19 a las 10:32, Prakash Ramakrishnan escribió:
Hi Tom,

I tried before getting this below meassage.

[root@brurhenaaa001 ~]# sudo apt-get install postgresql-pltcl-11
sudo: apt-get: command not found
[root@brurhenppp001 ~]# yum install postgresql-pltcl-11
Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager
rhel-7-server-eus-optional-rpms                                                                                                       | 2.0 kB  00:00:00
rhel-7-server-eus-satellite-tools-6.2-rpms                                                                                            | 2.1 kB  00:00:00
rhel-7-server-extras-rpms                                                                                                             | 2.0 kB  00:00:00
rhel-7-server-rpms                                                                                                                    | 2.0 kB  00:00:00
rhel-7-server-satellite-tools-6.2-rpms                                                                                                | 2.1 kB  00:00:00
rhel-server-rhscl-7-eus-rpms                                                                                                          | 2.0 kB  00:00:00
tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7                                                       | 2.1 kB  00:00:00
No package postgresql-pltcl-11 available.
Error: Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: langpacks, product-id, subscription-manager


On Tue, Mar 26, 2019 at 7:00 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> wrote:
Hi Tom,

Am using rhel 7.5 can you give some solution.

Regards,
Prakash.R

On Tue, Mar 26, 2019 at 6:52 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Christoph Berg <myon@debian.org> writes:
> Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
>> AIBE01PR=# create extension plctl;
>> ERROR:  could not open extension control file
>> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

> The extension is shipped in a separate package that you need to
> install on the operating system.

Perhaps even more to the point: the extension is pltcl, not plctl.

(Or at least, I assume you are after the Tcl PL extension.
If there is a "plctl", I haven't heard about it.)

                        regards, tom lane


--


Regards,
Prakash.R
Postgresql DBA


--


Regards,
Prakash.R
Postgresql DBA

Re: BUG #15714: plctl extension issue

From
Anthony Sotolongo
Date:
yes this are the packages
you must verify, which version is that you need, i dont know how you install postgres 11,
i dont know from repos that you installed,  but if you install from
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/

here the packages "postgresql11-tcl"  exist

verify yours repos
and this is off-topic in bugs list, please use other mailing list please



El 26-03-19 a las 10:58, Prakash Ramakrishnan escribió:
Hi Anthony,

Please find the logs,


[root@ brurhenaaa001   ~]# yum search pltcl
Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager
==================================================================== N/S matched: pltcl =====================================================================
postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQL
postgresql92-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQL
rh-postgresql10-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQL
rh-postgresql94-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQL
rh-postgresql95-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQL
rh-postgresql96-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQL

  Name and summary matches only, use "search all" for everything.
Uploading Enabled Repositories Report
Loaded plugins: langpacks, product-id, subscription-manager
[root@brurhenaaa001 ~]#
[root@ brurhenaaa001   ~]# yum install rh-postgresql11-postgresql-pltcl.x86_64
Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager
rhel-7-server-eus-optional-rpms                                                                                                       | 2.0 kB  00:00:00
rhel-7-server-eus-satellite-tools-6.2-rpms                                                                                            | 2.1 kB  00:00:00
rhel-7-server-extras-rpms                                                                                                             | 2.0 kB  00:00:00
rhel-7-server-rpms                                                                                                                    | 2.0 kB  00:00:00
rhel-7-server-satellite-tools-6.2-rpms                                                                                                | 2.1 kB  00:00:00
rhel-server-rhscl-7-eus-rpms                                                                                                          | 2.0 kB  00:00:00
tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7                                                       | 2.1 kB  00:00:00
No package rh-postgresql11-postgresql-pltcl.x86_64 available.
Error: Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: langpacks, product-id, subscription-manager


On Tue, Mar 26, 2019 at 7:16 PM Anthony Sotolongo <asotolongo@gmail.com> wrote:

Hello, apt-get is a distribution command debian and derivatives
you must search the name of packges in RHEL, try with
yum search pltcl or yum search tcl
 to get the real name in RHEL


regards

El 26-03-19 a las 10:32, Prakash Ramakrishnan escribió:
Hi Tom,

I tried before getting this below meassage.

[root@brurhenaaa001 ~]# sudo apt-get install postgresql-pltcl-11
sudo: apt-get: command not found
[root@brurhenppp001 ~]# yum install postgresql-pltcl-11
Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager
rhel-7-server-eus-optional-rpms                                                                                                       | 2.0 kB  00:00:00
rhel-7-server-eus-satellite-tools-6.2-rpms                                                                                            | 2.1 kB  00:00:00
rhel-7-server-extras-rpms                                                                                                             | 2.0 kB  00:00:00
rhel-7-server-rpms                                                                                                                    | 2.0 kB  00:00:00
rhel-7-server-satellite-tools-6.2-rpms                                                                                                | 2.1 kB  00:00:00
rhel-server-rhscl-7-eus-rpms                                                                                                          | 2.0 kB  00:00:00
tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7                                                       | 2.1 kB  00:00:00
No package postgresql-pltcl-11 available.
Error: Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: langpacks, product-id, subscription-manager


On Tue, Mar 26, 2019 at 7:00 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> wrote:
Hi Tom,

Am using rhel 7.5 can you give some solution.

Regards,
Prakash.R

On Tue, Mar 26, 2019 at 6:52 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Christoph Berg <myon@debian.org> writes:
> Re: PG Bug reporting form 2019-03-26 <15714-565b5e5a289218f5@postgresql.org>
>> AIBE01PR=# create extension plctl;
>> ERROR:  could not open extension control file
>> "/usr/pgsql-11/share/extension/plctl.control": No such file or directory

> The extension is shipped in a separate package that you need to
> install on the operating system.

Perhaps even more to the point: the extension is pltcl, not plctl.

(Or at least, I assume you are after the Tcl PL extension.
If there is a "plctl", I haven't heard about it.)

                        regards, tom lane


--


Regards,
Prakash.R
Postgresql DBA


--


Regards,
Prakash.R
Postgresql DBA


--


Regards,
Prakash.R
Postgresql DBA