Re: plctl extension issue postgresql 11.2

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Tue, 26 Mar 2019 10:37:54 -0700

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@xxxxxxxxxxx 
<mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx