Thread: Extension Activation
After a handful of installs, uninstalls and a current 10.6_1 (revision 1 on 10.6) on El Capitan (OS X), I can’t seem to getone extension working: mydb=# CREATE EXTENSION IF NOT EXISTS htore; ERROR: could not open extension control file "/usr/local/Cellar/postgresql@10/10.6_1/share/postgresql@10/extension/htore.control":No such file or directory However, it does exist: $ /usr/local/Cellar/postgresql@10/10.6_1/share/postgresql@10/extension] ll hstore.control -rw-r--r-- 1 rich admin 158B Feb 6 23:17 hstore.control I don’t think this is a homebrew error (the package manager I used to install PostgreSQL), but I’ve informed them. Is there anything that anybody sees here that I’m doing wrong? I’ve tried single quotations and double quotations around‘hstore’ and I get the same error. Other extensions install properly. Any advice appreciated.
On 12 February 2019 19:18:01 CET, BeeRich <beerich@gmail.com> wrote: >After a handful of installs, uninstalls and a current 10.6_1 (revision >1 on 10.6) on El Capitan (OS X), I can’t seem to get one extension >working: > >mydb=# CREATE EXTENSION IF NOT EXISTS htore; >ERROR: could not open extension control file >"/usr/local/Cellar/postgresql@10/10.6_1/share/postgresql@10/extension/htore.control": >No such file or directory > >However, it does exist: > >$ /usr/local/Cellar/postgresql@10/10.6_1/share/postgresql@10/extension] >ll hstore.control >-rw-r--r-- 1 rich admin 158B Feb 6 23:17 hstore.control > >I don’t think this is a homebrew error (the package manager I used to >install PostgreSQL), but I’ve informed them. > >Is there anything that anybody sees here that I’m doing wrong? I’ve >tried single quotations and double quotations around ‘hstore’ and I get >the same error. Other extensions install properly. > >Any advice appreciated. hstore, not htore. Missing s. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company
How do I get out of this list? Avec mes meilleures salutations / Bescht Gréiss / Mit freundlichen Grüssen / Kind regards Laurent Asorne Agence Immobilière Abby TOUSSAINT 32 81 73 41 laurent@confiance.lu www.confiance.lu > On 12 Feb 2019, at 19:18, BeeRich <beerich@gmail.com> wrote: > > After a handful of installs, uninstalls and a current 10.6_1 (revision 1 on 10.6) on El Capitan (OS X), I can’t seem toget one extension working: > > mydb=# CREATE EXTENSION IF NOT EXISTS htore; > ERROR: could not open extension control file "/usr/local/Cellar/postgresql@10/10.6_1/share/postgresql@10/extension/htore.control":No such file or directory > > However, it does exist: > > $ /usr/local/Cellar/postgresql@10/10.6_1/share/postgresql@10/extension] ll hstore.control > -rw-r--r-- 1 rich admin 158B Feb 6 23:17 hstore.control > > I don’t think this is a homebrew error (the package manager I used to install PostgreSQL), but I’ve informed them. > > Is there anything that anybody sees here that I’m doing wrong? I’ve tried single quotations and double quotations around‘hstore’ and I get the same error. Other extensions install properly. > > Any advice appreciated. > > > >