Thread: BUG #15714: plctl extension issue

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: 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

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

sudo apt-get install postgresql-pltcl-11

Regards

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

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

--

--

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

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

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

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