Обсуждение: 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 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
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.ROn 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
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.ROn 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.RPostgresql 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 Tom,I tried before getting this below meassage.[root@brurhenaaa001 ~]# sudo apt-get install postgresql-pltcl-11sudo: apt-get: command not found[root@brurhenppp001 ~]# yum install postgresql-pltcl-11Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-managerrhel-7-server-eus-optional-rpms | 2.0 kB 00:00:00rhel-7-server-eus-satellite-tools-6.2-rpms | 2.1 kB 00:00:00rhel-7-server-extras-rpms | 2.0 kB 00:00:00rhel-7-server-rpms | 2.0 kB 00:00:00rhel-7-server-satellite-tools-6.2-rpms | 2.1 kB 00:00:00rhel-server-rhscl-7-eus-rpms | 2.0 kB 00:00:00tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7 | 2.1 kB 00:00:00No package postgresql-pltcl-11 available.Error: Nothing to doUploading Enabled Repositories ReportLoaded plugins: langpacks, product-id, subscription-managerOn 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.ROn 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.RPostgresql DBA--Regards,Prakash.RPostgresql 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/
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 pltclLoaded 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 PostgreSQLpostgresql92-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQLrh-postgresql10-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQLrh-postgresql94-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQLrh-postgresql95-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQLrh-postgresql96-postgresql-pltcl.x86_64 : The Tcl procedural language for PostgreSQLName and summary matches only, use "search all" for everything.Uploading Enabled Repositories ReportLoaded plugins: langpacks, product-id, subscription-manager[root@brurhenaaa001 ~]#[root@ brurhenaaa001 ~]# yum install rh-postgresql11-postgresql-pltcl.x86_64Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-managerrhel-7-server-eus-optional-rpms | 2.0 kB 00:00:00rhel-7-server-eus-satellite-tools-6.2-rpms | 2.1 kB 00:00:00rhel-7-server-extras-rpms | 2.0 kB 00:00:00rhel-7-server-rpms | 2.0 kB 00:00:00rhel-7-server-satellite-tools-6.2-rpms | 2.1 kB 00:00:00rhel-server-rhscl-7-eus-rpms | 2.0 kB 00:00:00tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7 | 2.1 kB 00:00:00No package rh-postgresql11-postgresql-pltcl.x86_64 available.Error: Nothing to doUploading Enabled Repositories ReportLoaded plugins: langpacks, product-id, subscription-managerOn 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-11sudo: apt-get: command not found[root@brurhenppp001 ~]# yum install postgresql-pltcl-11Loaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-managerrhel-7-server-eus-optional-rpms | 2.0 kB 00:00:00rhel-7-server-eus-satellite-tools-6.2-rpms | 2.1 kB 00:00:00rhel-7-server-extras-rpms | 2.0 kB 00:00:00rhel-7-server-rpms | 2.0 kB 00:00:00rhel-7-server-satellite-tools-6.2-rpms | 2.1 kB 00:00:00rhel-server-rhscl-7-eus-rpms | 2.0 kB 00:00:00tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7 | 2.1 kB 00:00:00No package postgresql-pltcl-11 available.Error: Nothing to doUploading Enabled Repositories ReportLoaded plugins: langpacks, product-id, subscription-managerOn 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.ROn 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.RPostgresql DBA--Regards,Prakash.RPostgresql DBA--Regards,Prakash.RPostgresql DBA