BUG #15714: plctl extension issue

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

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

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

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

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

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

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

On 3/26/19 9:58 AM, Prakash Ramakrishnan wrote:

Hi Anthony,

Please find the logs,

Hi Prakash,

While we're happy to help you, this mailing list is specific for
reporting, investigating, and fixing bugs found in PostgreSQL. If you
are looking for general support, please try one of the resources
available here:

https://www.postgresql.org/support/

Your recent questions have been appropriate for the

pgsql-general@lists.postgresql.org

mailing list. I kindly ask that you direct your future inquiries there.

Thanks,

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development