How To Install Postgres On Windows
I'm trying to install hstore in Postgres on Mac OSX 10.9, but I'm having major troubles with it. First I had some trouble getting psql to work after installing postgresql using brew, so I finally installed Postgres using postgresql.app. After that I logged into psql, created a database and tried creating the hstore extension using
CREATE EXTENSION hstore;, which throws me an error saying
ERROR: could not open extension control file '/usr/local/Cellar/postgresql/9.3.2/share/postgresql/extension/hstore.control': No such file or directory.
Best Way To Install Postgres On Mac For Database Development
I guess that path refers to a brew install, which doesn't exist (I uninstalled the brew version). Would anybody know how I can still install the hstore extension now?
I'm rather lost here, so all tips are welcome!kramer65
You didn't actually uninstall the Brew version fully. The PostgreSQL you are connected to is using
$libdir, which is a Homebrew path.
I'd say you just unlinked it from /usr/local, you didn't really uninstall it, and it's still running quite happily.
Even if you actually deleted it, on Mac OS X (like most OSes except Windows) you can delete a file that's still open - so PostgreSQL can potentially be still running, even though the files have been deleted. The OS will really delete them when they are closed.Craig RingerCraig Ringer