Thread
-
BUG #15714: plctl extension issue
PG Bug reporting form <noreply@postgresql.org> — 2019-03-26T10:59:27Z
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
Christoph Berg <myon@debian.org> — 2019-03-26T12:08:25Z
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
Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> — 2019-03-26T12:31:50Z
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
Anthony Sotolongo <asotolongo@gmail.com> — 2019-03-26T12:52:05Z
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 > <mailto:myon@debian.org>> wrote: > > Re: PG Bug reporting form 2019-03-26 > <15714-565b5e5a289218f5@postgresql.org > <mailto: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
Tom Lane <tgl@sss.pgh.pa.us> — 2019-03-26T13:22:39Z
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
Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> — 2019-03-26T13:30:52Z
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
Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> — 2019-03-26T13:32:10Z
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
Anthony Sotolongo <asotolongo@gmail.com> — 2019-03-26T13:45:57Z
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 > <mailto: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 > <mailto:tgl@sss.pgh.pa.us>> wrote: > > Christoph Berg <myon@debian.org <mailto:myon@debian.org>> writes: > > Re: PG Bug reporting form 2019-03-26 > <15714-565b5e5a289218f5@postgresql.org > <mailto: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
Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> — 2019-03-26T13:58:05Z
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 -
Re: BUG #15714: plctl extension issue
Anthony Sotolongo <asotolongo@gmail.com> — 2019-03-26T14:06:58Z
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 <mailto: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 >> <mailto: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 >> <mailto:tgl@sss.pgh.pa.us>> wrote: >> >> Christoph Berg <myon@debian.org <mailto:myon@debian.org>> >> writes: >> > Re: PG Bug reporting form 2019-03-26 >> <15714-565b5e5a289218f5@postgresql.org >> <mailto: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
-
Re: BUG #15714: plctl extension issue
Joe Conway <mail@joeconway.com> — 2019-03-26T14:55:36Z
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