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
wrote:
>
>
> On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan <
> prakash.ramakrishnan...
On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan <
prakash.ramakrishnan...@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.
>
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 exte
Thanks, I'll check it out.
On Thu, Mar 28, 2019, 20:26 Tom Lane wrote:
> Adrian Klaver 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 bee
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 "A
Adrian Klaver 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:
> postgresq
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 fo
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
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-
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
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 fr
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.
Nope I tried that's command and getting above error control file missing.
On Tue, Mar 26, 2019, 22:53 Adrian Klaver 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
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 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
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.htm
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/
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
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/plc
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
--
19 matches
Mail list logo
