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