![]() ![]() ![]() How to use extensions in Postgres installed with Homebrew on Mac OSX.Postgres createuser command not found after installing with homebrew on my Mac.broken create, save, update, and destroy on Join record when using Postgres UUIDs in Rails.Where does Homebrew install Postgres executables?.Should show you the tables and user permissions in postgre after such manipulations. The following command, run as the dev user, should then properly populate the directory: createdb `whoami` In addition, if, like me, you have an admin user managing homebrew and a regular user who will be using pgsl for development purpose, James command should be run as super user: sudo -sĪnd ownership over the postgres directory should be given to your dev user: chown my-dev-user /usr/local/var/postgres rm -rf /usr/local/var/postgres # in case this is not your first try You should first unload it: launchctl unload ~/Library/LaunchAgents/īefore running James's commands. The issue is that if you have created the symlink: ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgentsĪnd launched the process: launchctl load ~/Library/LaunchAgents/ But I then ran into the issue jbk is mentioning (after having deleted /usr/local/var/postgres, it kept on being recreated). Please note that their is a thread on Homebrew's github dealing with this issue: This seemed to have done the trick and postgres is running fine. So I removed the directory /usr/local/var/postgres and issued the command to initialize the database. Postgres cannot access the server configuration file "/usr/local/var/postgres/nf": No such file or directory This was easily changed issuing sudo chown -R `whoami` /usr/local/var/postgres then I reinstalled postgresql and did HEAD: 9f6926265f8e4be7cc80dfe9042f2cd3c1e8dc9eįirst thing i noticed was that I had no write permission to /usr/local/var/postgres. I had the same problem installing postgres using homebrew on a freshly installed Yosemite.įirst off my brew config looks like this: HOMEBREW_VERSION: 0.9.5 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |