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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com