Thanks for your big help i did yum install plctl and extension below path but still am getting error please find the below details,
==> psql
psql (11.2)
Type "help" for help.
postgres=# \c "AIBE01PR"
You are now connected to database "AIBE01PR" as user "postgres".
AIBE01PR=# create extension plctl;
ERROR: could not open extension control file "/usr/pgsql-11/share/extension/plctl.control": No such file or directory
AIBE01PR=#
If that is cut/and/pasted, then it is crystal clear that it won't work because there's a typo.
There is no such computer language as "ctl". And therefore...
There is no such PostgreSQL extension as "plctl"
Try "create extension pltcl;" instead.
It is an absolute certainty that "create extension plctl;" WILL NOT WORK, regardless of what software you may have installed. In contrast "create extension pltcl;" may quite possibly work.
Many of us don't use your Linux distribution, so can only take wild guesses as to what commands might install what RPM files that might be helpful.
You almost certainly did not "yum install plctl" with much success, though conceivably "yum install pltcl" might have worked instead.
--
When confronted by a difficult problem, solve it by reducing it to the question, "How would the Lone Ranger handle this?"
