plctl extension issue postgresql 11.2

Started by Prakash Ramakrishnanabout 7 years ago19 messagesgeneral

Jump to latest

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

Hi Team,

We are getting below error in production server please do the needful.

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

RHEL-7.5
--

Regards,
Prakash.R
Postgresql DBA

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#1)

Re: plctl extension issue postgresql 11.2

On 3/26/19 8:56 AM, Prakash Ramakrishnan wrote:

Hi Team,

We are getting below error in production server please do the needful.

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

I am guessing you actually want:

CREATE EXTENSION pltcl;

RHEL-7.5
--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Adrian Klaver (#2)

Re: plctl extension issue postgresql 11.2

Nope I tried that's command and getting above error control file missing.

On Tue, Mar 26, 2019, 22:53 Adrian Klaver <adrian.klaver@aklaver.com> wrote:

Show quoted text

On 3/26/19 8:56 AM, Prakash Ramakrishnan wrote:

Hi Team,

We are getting below error in production server please do the needful.

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

I am guessing you actually want:

CREATE EXTENSION pltcl;

RHEL-7.5
--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#3)

Re: plctl extension issue postgresql 11.2

On 3/26/19 10:32 AM, Prakash Ramakrishnan wrote:

Nope I tried that's command and getting above error control file missing.

Well it should be a different message something like:

/usr/pgsql-11/share/extension/pltctl.control": No such file or directory

correct?

If the above is the case then:

1) How did you install Postgres, package or source?

2) If package, from where?

3) What does pg_config show in the CONFIGURE section?

On Tue, Mar 26, 2019, 22:53 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 3/26/19 8:56 AM, Prakash Ramakrishnan wrote:

Hi Team,

We are getting below error in production server please do

the needful.

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

I am guessing you actually want:

CREATE EXTENSION pltcl;

RHEL-7.5
--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Adrian Klaver (#4)

Re: plctl extension issue postgresql 11.2

I did postgres 11.2 version using yum option this file only Missing and
using rhel 7.5 version.

On Tue, Mar 26, 2019, 23:07 Adrian Klaver <adrian.klaver@aklaver.com> wrote:

Show quoted text

On 3/26/19 10:32 AM, Prakash Ramakrishnan wrote:

Nope I tried that's command and getting above error control file missing.

Well it should be a different message something like:

/usr/pgsql-11/share/extension/pltctl.control": No such file or directory

correct?

If the above is the case then:

1) How did you install Postgres, package or source?

2) If package, from where?

3) What does pg_config show in the CONFIGURE section?

On Tue, Mar 26, 2019, 22:53 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 3/26/19 8:56 AM, Prakash Ramakrishnan wrote:

Hi Team,

We are getting below error in production server please do

the needful.

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

I am guessing you actually want:

CREATE EXTENSION pltcl;

RHEL-7.5
--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#5)

Re: plctl extension issue postgresql 11.2

On 3/26/19 10:43 AM, Prakash Ramakrishnan wrote:

I did postgres 11.2 version using yum option this file only Missing and
using rhel 7.5 version.

Please respond to all questions below:

YUM using what repo's?

From command line what does pg_config show?

Have you looked in:

/usr/pgsql-11/share/extension/

to see if file actually exists or that the directory exists?

On Tue, Mar 26, 2019, 23:07 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 3/26/19 10:32 AM, Prakash Ramakrishnan wrote:

Nope I tried that's command and getting above error control file

missing.

Well it should be a different message something like:

/usr/pgsql-11/share/extension/pltctl.control": No such file or directory

correct?

If the above is the case then:

1) How did you install Postgres, package or source?

2) If package, from where?

3) What does pg_config show in the CONFIGURE section?

On Tue, Mar 26, 2019, 22:53 Adrian Klaver

<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

<mailto:adrian.klaver@aklaver.com

<mailto:adrian.klaver@aklaver.com>>> wrote:

On 3/26/19 8:56 AM, Prakash Ramakrishnan wrote:
> Hi Team,
>
> We are getting below error in production server please do
the needful.
>
> ==> 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

I am guessing you actually want:

CREATE EXTENSION pltcl;

>
> RHEL-7.5
> --
>
>
> Regards,
> Prakash.R
> Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

<mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#5)

Re: plctl extension issue postgresql 11.2

On 3/26/19 10:43 AM, Prakash Ramakrishnan wrote:

I did postgres 11.2 version using yum option this file only Missing and
using rhel 7.5 version.

If you are using the PGDG repos then it looks like you need:

https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/letter_p.group.html

postgresql11-pltcl

Not sure if that would also work for the RH repos.

--
Adrian Klaver
adrian.klaver@aklaver.com

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Adrian Klaver (#7)

Re: plctl extension issue postgresql 11.2

Hi Adrian,

Sorry for late reply am try to install the plctl but still getting error.

[root@brurhenaaa001 postgres]# rpm -ivh
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64.rpm
error: Failed dependencies:
postgresql11(x86-64) = 11.2-2PGDG.rhel7 is needed by
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
postgresql11-server(x86-64) = 11.2-2PGDG.rhel7 is needed by
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
[root@ brurhenaaa001 postgres]#
[root@ brurhenaaa001 postgres]#

On Tue, Mar 26, 2019 at 11:26 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 3/26/19 10:43 AM, Prakash Ramakrishnan wrote:

I did postgres 11.2 version using yum option this file only Missing and
using rhel 7.5 version.

If you are using the PGDG repos then it looks like you need:

https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/letter_p.group.html

postgresql11-pltcl

Not sure if that would also work for the RH repos.

--
Adrian Klaver
adrian.klaver@aklaver.com

Regards,
Prakash.R
Postgresql DBA

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#8)

Re: plctl extension issue postgresql 11.2

On 3/27/19 2:46 AM, Prakash Ramakrishnan wrote:

Hi Adrian,

Sorry for late reply am try to install the plctl but still getting error.

From looks of it you did not do the original install of Postgres from
the PGDG repos. The first thing you need to figure out is where you
installed Postgres from? I am not a RH user, but I believe the below
might help:

yum list installed | grep -i postgresql

[root@brurhenaaa001 postgres]# rpm -ivh
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64.rpm
error: Failed dependencies:
postgresql11(x86-64) = 11.2-2PGDG.rhel7 is needed by
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
postgresql11-server(x86-64) = 11.2-2PGDG.rhel7 is needed by
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
[root@ brurhenaaa001 postgres]#
[root@ brurhenaaa001 postgres]#

On Tue, Mar 26, 2019 at 11:26 PM Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

On 3/26/19 10:43 AM, Prakash Ramakrishnan wrote:

I did postgres 11.2 version using yum option this file only

Missing and

using rhel 7.5 version.

If you are using the PGDG repos then it looks like you need:

https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/letter_p.group.html

postgresql11-pltcl

Not sure if that would also work for the RH repos.

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com

#10

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Adrian Klaver (#9)

Re: plctl extension issue postgresql 11.2

Hi Adrian,

Sorry for the late reply please find the below details,

[root@brurhenaaa001 postgres]# yum list installed | grep -i postgresql
postgresql.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-devel.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-jdbc.noarch 9.2.1002-6.el7_5
@rhel-7-server-rpms
postgresql-libs.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-odbc.x86_64 09.03.0100-2.el7
@rhel-7-server-rpms
postgresql-pgpool-II.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-devel.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-extensions.x86_64
postgresql-plruby.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-plruby-doc.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pltcl.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-server.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
*postgresql11.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-contrib.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-devel.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-libs.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-server.x86_64 11.2-1PGDG.rhel7 @pgdg11*

On Wed, Mar 27, 2019 at 7:39 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 3/27/19 2:46 AM, Prakash Ramakrishnan wrote:

Hi Adrian,

Sorry for late reply am try to install the plctl but still getting error.

From looks of it you did not do the original install of Postgres from
the PGDG repos. The first thing you need to figure out is where you
installed Postgres from? I am not a RH user, but I believe the below
might help:

yum list installed | grep -i postgresql

[root@brurhenaaa001 postgres]# rpm -ivh
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64.rpm
error: Failed dependencies:
postgresql11(x86-64) = 11.2-2PGDG.rhel7 is needed by
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
postgresql11-server(x86-64) = 11.2-2PGDG.rhel7 is needed by
postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64
[root@ brurhenaaa001 postgres]#
[root@ brurhenaaa001 postgres]#

On Tue, Mar 26, 2019 at 11:26 PM Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

On 3/26/19 10:43 AM, Prakash Ramakrishnan wrote:

I did postgres 11.2 version using yum option this file only

Missing and

using rhel 7.5 version.

If you are using the PGDG repos then it looks like you need:

https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/letter_p.group.html

postgresql11-pltcl

Not sure if that would also work for the RH repos.

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com

Regards,
Prakash.R
Postgresql DBA

#11

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#10)

Re: plctl extension issue postgresql 11.2

On 3/27/19 8:32 AM, Prakash Ramakrishnan wrote:

Hi Adrian,

Sorry for the late reply please find the below details,

Again I am not a RH user so take the following with that in mind.

What if you do?:

sudo yum install postgresql11-tcl

[root@brurhenaaa001 postgres]# yum list installed | grep -i postgresql
postgresql.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-devel.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-jdbc.noarch 9.2.1002-6.el7_5
@rhel-7-server-rpms
postgresql-libs.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-odbc.x86_64 09.03.0100-2.el7
@rhel-7-server-rpms
postgresql-pgpool-II.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-devel.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-extensions.x86_64
postgresql-plruby.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-plruby-doc.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pltcl.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-server.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
*postgresql11.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-contrib.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-devel.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-libs.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-server.x86_64 11.2-1PGDG.rhel7 @pgdg11*

--
Adrian Klaver
adrian.klaver@aklaver.com

#12

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Adrian Klaver (#11)

Re: plctl extension issue postgresql 11.2

Hi Adrian,

I tried which command you gave but its not working.please check,

[root@brurhenaaa001 postgres]# yum install postgresql11-tcl
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 postgresql11-tcl available.
Error: Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: langpacks, product-id, subscription-manager

On Wed, Mar 27, 2019 at 9:53 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 3/27/19 8:32 AM, Prakash Ramakrishnan wrote:

Hi Adrian,

Sorry for the late reply please find the below details,

Again I am not a RH user so take the following with that in mind.

What if you do?:

sudo yum install postgresql11-tcl

[root@brurhenaaa001 postgres]# yum list installed | grep -i postgresql
postgresql.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-devel.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-jdbc.noarch 9.2.1002-6.el7_5
@rhel-7-server-rpms
postgresql-libs.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-odbc.x86_64 09.03.0100-2.el7
@rhel-7-server-rpms
postgresql-pgpool-II.x86_64 3.4.6-1.el7

@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7

postgresql-pgpool-II-devel.x86_64 3.4.6-1.el7

@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7

postgresql-pgpool-II-extensions.x86_64
postgresql-plruby.x86_64 0.5.3-13.el7

@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7

postgresql-plruby-doc.x86_64 0.5.3-13.el7

@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7

postgresql-pltcl.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-server.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
*postgresql11.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-contrib.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-devel.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-libs.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11*
*postgresql11-server.x86_64 11.2-1PGDG.rhel7 @pgdg11*

--
Adrian Klaver
adrian.klaver@aklaver.com

Regards,
Prakash.R
Postgresql DBA

#13

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#12)

Re: plctl extension issue postgresql 11.2

On 3/28/19 3:20 AM, Prakash Ramakrishnan wrote:

Hi Adrian,

I tried which command you gave but its not working.please check,

First I posted the wrong package name previously. For the Tcl PL it
should be:

postgresql11-pltcl

Still postgresql11-tcl is a valid package in the PGDG repos(it is for a
Tcl client library). It is trying to find postgresql11-tcl in the RHEL
repo not the PGDG repo. Yet packages have been installed from the PGDG
repo(from previous post) in the past:

postgresql11.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-contrib.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-devel.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-libs.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-server.x86_64 11.2-1PGDG.rhel7 @pgdg11

You will need to sort out how the above packages where installed and
replicate that for the pltcl package. I cannot be of more help as I do
not use RH. Maybe someone else can chime in.

[root@brurhenaaa001 postgres]# yum install postgresql11-tcl
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 postgresql11-tcl available.
Error: Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: langpacks, product-id, subscription-manager

--
Adrian Klaver
adrian.klaver@aklaver.com

#14

Tom Lane

tgl@sss.pgh.pa.us

about 7 years ago

In reply to: Adrian Klaver (#13)

Re: plctl extension issue postgresql 11.2

Adrian Klaver <adrian.klaver@aklaver.com> writes:

Still postgresql11-tcl is a valid package in the PGDG repos(it is for a
Tcl client library). It is trying to find postgresql11-tcl in the RHEL
repo not the PGDG repo. Yet packages have been installed from the PGDG
repo(from previous post) in the past:

postgresql11.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-contrib.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-devel.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-libs.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-server.x86_64 11.2-1PGDG.rhel7 @pgdg11

You will need to sort out how the above packages where installed and
replicate that for the pltcl package. I cannot be of more help as I do
not use RH. Maybe someone else can chime in.

Yeah. The PGDG package repo is evidently not being searched by yum,
so it's either been removed or disabled in yum's repo configuration
list. (It must have been there at one time, unless you used a
*really* nonstandard way of installing those RPMs.)

Look into /etc/yum.repos.d/ ... if you see a file for the PGDG repo,
fix it to be enabled, otherwise you need to download and install that
repo config file.

regards, tom lane

#15

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Tom Lane (#14)

Re: plctl extension issue postgresql 11.2

Thanks, I'll check it out.

On Thu, Mar 28, 2019, 20:26 Tom Lane <tgl@sss.pgh.pa.us> wrote:

Show quoted text

Adrian Klaver <adrian.klaver@aklaver.com> writes:

Still postgresql11-tcl is a valid package in the PGDG repos(it is for a
Tcl client library). It is trying to find postgresql11-tcl in the RHEL
repo not the PGDG repo. Yet packages have been installed from the PGDG
repo(from previous post) in the past:

postgresql11.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-contrib.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-devel.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-libs.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-server.x86_64 11.2-1PGDG.rhel7 @pgdg11

You will need to sort out how the above packages where installed and
replicate that for the pltcl package. I cannot be of more help as I do
not use RH. Maybe someone else can chime in.

Yeah. The PGDG package repo is evidently not being searched by yum,
so it's either been removed or disabled in yum's repo configuration
list. (It must have been there at one time, unless you used a
*really* nonstandard way of installing those RPMs.)

Look into /etc/yum.repos.d/ ... if you see a file for the PGDG repo,
fix it to be enabled, otherwise you need to download and install that
repo config file.

regards, tom lane

#16

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#15)

Re: plctl extension issue postgresql 11.2

Hi Tom,

Thanks for your big help i did yum install plctl and extension below path
but still am getting error please find the below details,

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

postgres=# \c "AIBE01PR"
You are now connected to database "AIBE01PR" as user "postgres".
*AIBE01PR=# create extension plctl;*
*ERROR: could not open extension control file
"/usr/pgsql-11/share/extension/plctl.control": No such file or directory*
*AIBE01PR=#*
AIBE01PR=# \q
postgres@ brurhenaaa001 .enterprisenet.org:/home/postgres
==> sudo su -
Last login: Thu Mar 28 17:02:53 CET 2019 on pts/0
[root@ brurhenaaa001 ~]# yum list installed | grep -i postgresql
postgresql.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-devel.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-jdbc.noarch 9.2.1002-6.el7_5
@rhel-7-server-rpms
postgresql-libs.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-odbc.x86_64 09.03.0100-2.el7
@rhel-7-server-rpms
postgresql-pgpool-II.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-devel.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-extensions.x86_64
postgresql-plruby.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-plruby-doc.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pltcl.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-server.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
*postgresql11.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-contrib.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-devel.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-libs.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-llvmjit.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-pltcl.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-server.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-tcl.x86_64 2.4.0-2.rhel7.1 @pgdg11*
[root@brurhenaaa001 ~]# cd /usr/pgsql-11/share/extension
[root@ brurhenaaa001 extension]# ls
adminpack--1.0--1.1.sql fuzzystrmatch--1.1.sql
oracle_fdw--1.0--1.1.sql pg_trgm--1.3--1.4.sql
adminpack--1.0.sql fuzzystrmatch.control
oracle_fdw--1.1.sql pg_trgm--1.3.sql
adminpack--1.1--2.0.sql fuzzystrmatch--unpackaged--1.0.sql
oracle_fdw.control pg_trgm.control
adminpack.control hstore--1.0--1.1.sql
pageinspect--1.0--1.1.sql pg_trgm--unpackaged--1.0.sql
amcheck--1.0--1.1.sql hstore--1.1--1.2.sql
pageinspect--1.1--1.2.sql pg_visibility--1.0--1.1.sql
amcheck--1.0.sql hstore--1.2--1.3.sql
pageinspect--1.2--1.3.sql pg_visibility--1.1--1.2.sql
amcheck.control hstore--1.3--1.4.sql
pageinspect--1.3--1.4.sql pg_visibility--1.1.sql
autoinc--1.0.sql hstore--1.4--1.5.sql
pageinspect--1.4--1.5.sql pg_visibility.control
autoinc.control hstore--1.4.sql
pageinspect--1.5--1.6.sql plpgsql--1.0.sql
autoinc--unpackaged--1.0.sql hstore.control
pageinspect--1.5.sql plpgsql.control
bloom--1.0.sql hstore_plperl--1.0.sql
pageinspect--1.6--1.7.sql plpgsql--unpackaged--1.0.sql
bloom.control hstore_plperl.control
pageinspect.control *pltcl--1.0.sql*
btree_gin--1.0--1.1.sql hstore_plperlu--1.0.sql
pageinspect--unpackaged--1.0.sql * pltcl.control*
btree_gin--1.0.sql hstore_plperlu.control
pg_buffercache--1.0--1.1.sql * pltclu--1.0.sql*

On Thu, Mar 28, 2019 at 9:09 PM Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> wrote:

Thanks, I'll check it out.

On Thu, Mar 28, 2019, 20:26 Tom Lane <tgl@sss.pgh.pa.us> wrote:

Adrian Klaver <adrian.klaver@aklaver.com> writes:

Still postgresql11-tcl is a valid package in the PGDG repos(it is for a
Tcl client library). It is trying to find postgresql11-tcl in the RHEL
repo not the PGDG repo. Yet packages have been installed from the PGDG
repo(from previous post) in the past:

postgresql11.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-contrib.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-devel.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-libs.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11
postgresql11-server.x86_64 11.2-1PGDG.rhel7 @pgdg11

You will need to sort out how the above packages where installed and
replicate that for the pltcl package. I cannot be of more help as I do
not use RH. Maybe someone else can chime in.

Yeah. The PGDG package repo is evidently not being searched by yum,
so it's either been removed or disabled in yum's repo configuration
list. (It must have been there at one time, unless you used a
*really* nonstandard way of installing those RPMs.)

Look into /etc/yum.repos.d/ ... if you see a file for the PGDG repo,
fix it to be enabled, otherwise you need to download and install that
repo config file.

regards, tom lane

Regards,
Prakash.R
Postgresql DBA

#17

Adrian Klaver

adrian.klaver@aklaver.com

about 7 years ago

In reply to: Prakash Ramakrishnan (#16)

Re: plctl extension issue postgresql 11.2

On 3/28/19 9:07 AM, Prakash Ramakrishnan wrote:

Hi Tom,

Thanks for your big help i did yum install plctl and extension below
path but still am getting error please find the below details,

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

postgres=# \c "AIBE01PR"
You are now connected to database "AIBE01PR" as user "postgres".
*AIBE01PR=# create extension plctl;*
*ERROR: could not open extension control file
"/usr/pgsql-11/share/extension/plctl.control": No such file or directory*

Try:
create extension pltcl;

*AIBE01PR=#*
AIBE01PR=# \q
postgres@ brurhenaaa001   .enterprisenet.org:/home/postgres
==> sudo su -
Last login: Thu Mar 28 17:02:53 CET 2019 on pts/0
[root@ brurhenaaa001   ~]# yum list installed | grep -i postgresql
postgresql.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-devel.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-jdbc.noarch 9.2.1002-6.el7_5
@rhel-7-server-rpms
postgresql-libs.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-odbc.x86_64 09.03.0100-2.el7
@rhel-7-server-rpms
postgresql-pgpool-II.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-devel.x86_64 3.4.6-1.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pgpool-II-extensions.x86_64
postgresql-plruby.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-plruby-doc.x86_64 0.5.3-13.el7
@tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7
postgresql-pltcl.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
postgresql-server.x86_64 9.2.24-1.el7_5
@rhel-7-server-rpms
*postgresql11.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-contrib.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-devel.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-libs.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-llvmjit.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-pltcl.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-server.x86_64 11.2-2PGDG.rhel7 @pgdg11*
*postgresql11-tcl.x86_64 2.4.0-2.rhel7.1 @pgdg11*
[root@brurhenaaa001 ~]# cd /usr/pgsql-11/share/extension
[root@ brurhenaaa001   extension]# ls
adminpack--1.0--1.1.sql fuzzystrmatch--1.1.sql
oracle_fdw--1.0--1.1.sql pg_trgm--1.3--1.4.sql
adminpack--1.0.sql fuzzystrmatch.control
oracle_fdw--1.1.sql pg_trgm--1.3.sql
adminpack--1.1--2.0.sql fuzzystrmatch--unpackaged--1.0.sql
oracle_fdw.control pg_trgm.control
adminpack.control hstore--1.0--1.1.sql
pageinspect--1.0--1.1.sql pg_trgm--unpackaged--1.0.sql
amcheck--1.0--1.1.sql hstore--1.1--1.2.sql
pageinspect--1.1--1.2.sql pg_visibility--1.0--1.1.sql
amcheck--1.0.sql hstore--1.2--1.3.sql
pageinspect--1.2--1.3.sql pg_visibility--1.1--1.2.sql
amcheck.control hstore--1.3--1.4.sql
pageinspect--1.3--1.4.sql pg_visibility--1.1.sql
autoinc--1.0.sql hstore--1.4--1.5.sql
pageinspect--1.4--1.5.sql pg_visibility.control
autoinc.control hstore--1.4.sql
pageinspect--1.5--1.6.sql plpgsql--1.0.sql
autoinc--unpackaged--1.0.sql hstore.control
pageinspect--1.5.sql plpgsql.control
bloom--1.0.sql hstore_plperl--1.0.sql
pageinspect--1.6--1.7.sql plpgsql--unpackaged--1.0.sql
bloom.control hstore_plperl.control
pageinspect.control *pltcl--1.0.sql*
btree_gin--1.0--1.1.sql hstore_plperlu--1.0.sql
pageinspect--unpackaged--1.0.sql * pltcl.control*
btree_gin--1.0.sql hstore_plperlu.control
pg_buffercache--1.0--1.1.sql * pltclu--1.0.sql*

On Thu, Mar 28, 2019 at 9:09 PM Prakash Ramakrishnan
<prakash.ramakrishnan.ap@nielsen.com
<mailto:prakash.ramakrishnan.ap@nielsen.com>> wrote:

Thanks, I'll check it out.

On Thu, Mar 28, 2019, 20:26 Tom Lane <tgl@sss.pgh.pa.us
<mailto:tgl@sss.pgh.pa.us>> wrote:

Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> writes:

Still postgresql11-tcl is a valid package in the PGDG

repos(it is for a

Tcl client library). It is trying to find postgresql11-tcl in

the RHEL

repo not the PGDG repo. Yet packages have been installed

from the PGDG

repo(from previous post) in the past:

postgresql11.x86_64 11.2-1PGDG.rhel7

@pgdg11

postgresql11-contrib.x86_64 11.2-1PGDG.rhel7

@pgdg11

postgresql11-devel.x86_64 11.2-1PGDG.rhel7

@pgdg11

postgresql11-libs.x86_64 11.2-1PGDG.rhel7

@pgdg11

postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7

@pgdg11

postgresql11-server.x86_64 11.2-1PGDG.rhel7

@pgdg11

You will need to sort out how the above packages where

installed and

replicate that for the pltcl package. I cannot be of more

help as I do

not use RH. Maybe someone else can chime in.

Yeah. The PGDG package repo is evidently not being searched by yum,
so it's either been removed or disabled in yum's repo configuration
list. (It must have been there at one time, unless you used a
*really* nonstandard way of installing those RPMs.)

Look into /etc/yum.repos.d/ ... if you see a file for the PGDG repo,
fix it to be enabled, otherwise you need to download and install
that
repo config file.

regards, tom lane

--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com

#18

Chris Browne

cbbrowne@acm.org

about 7 years ago

In reply to: Prakash Ramakrishnan (#16)

Re: plctl extension issue postgresql 11.2

On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> wrote:

Hi Tom,

Thanks for your big help i did yum install plctl and extension below path
but still am getting error please find the below details,

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

postgres=# \c "AIBE01PR"
You are now connected to database "AIBE01PR" as user "postgres".
*AIBE01PR=# create extension plctl;*
*ERROR: could not open extension control file
"/usr/pgsql-11/share/extension/plctl.control": No such file or directory*
*AIBE01PR=#*

If that is cut/and/pasted, then it is crystal clear that it won't work
because there's a typo.

There is no such computer language as "ctl". And therefore...
There is no such PostgreSQL extension as "plctl"

Try "create extension pltcl;" instead.

It is an absolute certainty that "create extension plctl;" WILL NOT WORK,
regardless of what software you may have installed. In contrast "create
extension pltcl;" may quite possibly work.

Many of us don't use your Linux distribution, so can only take wild guesses
as to what commands might install what RPM files that might be helpful.

You almost certainly did not "yum install plctl" with much success, though
conceivably "yum install pltcl" might have worked instead.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"

#19

Prakash Ramakrishnan

prakash.ramakrishnan.ap@nielsen.com

about 7 years ago

In reply to: Chris Browne (#18)

Re: plctl extension issue postgresql 11.2

Hi Christopher,Adrian,Tom

Thanks for quick response finally i did the pltcl install extension
activity done thanks for your support.

Regards,
Prakash.R

On Fri, Mar 29, 2019 at 3:08 AM Christopher Browne <cbbrowne@gmail.com>
wrote:

On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> wrote:

Hi Tom,

Thanks for your big help i did yum install plctl and extension below path
but still am getting error please find the below details,

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

postgres=# \c "AIBE01PR"
You are now connected to database "AIBE01PR" as user "postgres".
*AIBE01PR=# create extension plctl;*
*ERROR: could not open extension control file
"/usr/pgsql-11/share/extension/plctl.control": No such file or directory*
*AIBE01PR=#*

If that is cut/and/pasted, then it is crystal clear that it won't work
because there's a typo.

There is no such computer language as "ctl". And therefore...
There is no such PostgreSQL extension as "plctl"

Try "create extension pltcl;" instead.

It is an absolute certainty that "create extension plctl;" WILL NOT WORK,
regardless of what software you may have installed. In contrast "create
extension pltcl;" may quite possibly work.

Many of us don't use your Linux distribution, so can only take wild
guesses as to what commands might install what RPM files that might be
helpful.

You almost certainly did not "yum install plctl" with much success, though
conceivably "yum install pltcl" might have worked instead.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"

Regards,
Prakash.R
Postgresql DBA