• Home
  • pcDuino
  • WiKi
  • Store
  • Distributors
  • Home
  • pcDuino
  • WiKi
  • Store
  • Distributors
HomepcDuinoLinux ApplicationsPostgreSQL: ERROR: could not open extension contr ...
Previous Next

PostgreSQL: ERROR: could not open extension control file “/usr/share/postgresql/9.3/extension/tablefunc.control”: No such file or directory

Posted by: Yang , July 7, 2014

Question:

There should be more problems when trying to create the 5 extensions

$ psql  -U postgres book -c "CREATE EXTENSION tablefunc"
ERROR:  could not open extension control file "/usr/share/postgresql/9.3/extension/tablefunc.control": No such file or directory

How to Fix :

You can fix it by just downloading a package.

$ sudo apt-get install postgresql-contrib

Downloading the postgresql-contrib packages will give the ability to use the following five commands:

$ psql  -U postgres book -c "CREATE EXTENSION tablefunc"
$ psql  -U postgres book -c "CREATE EXTENSION hellopcduino"
$ psql  -U postgres book -c "CREATE EXTENSION ilovepcduino"
$ psql  -U postgres book -c "CREATE EXTENSION pcduinoisbest"
$ psql  -U postgres book -c "CREATE EXTENSION hellolinksprite"

And now you should be good to go!

Tags: Linux Applications

Share!
Tweet

Yang

About the author

Leave a Reply Cancel reply

You must be logged in to post a comment.

Category

  • Home
  • pcDuino
  • WiKi
  • Store
  • Distributors