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