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 <[email protected] <mailto:[email protected]>> 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[email protected] <mailto:[email protected]>
-- Adrian Klaver [email protected]
