`pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan)

Solved… in part. Apparently, Installing the latest versions of OS X (e.g. Yosemite or El Capitan) removes some directories in /usr/local/var/postgres. To fix this you simply recreate the missing directories: mkdir -p /usr/local/var/postgres/pg_commit_ts mkdir -p /usr/local/var/postgres/pg_dynshmem mkdir -p /usr/local/var/postgres/pg_logical/mappings mkdir -p /usr/local/var/postgres/pg_logical/snapshots mkdir -p /usr/local/var/postgres/pg_replslot mkdir -p /usr/local/var/postgres/pg_serial mkdir -p /usr/local/var/postgres/pg_snapshots mkdir -p /usr/local/var/postgres/pg_stat mkdir … Read more

dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.62.dylib error running php after installing node with brew on Mac

Update – As stated in some of the comments, running brew cleanup could possibly fix this error, if that alone doesn’t fix it, you might try upgrading individual packages or all your brew packages. I just had this same problem. Upgrading Homebrew and then cleaning up worked for me. This error likely showed up for … Read more

How to fix homebrew permissions?

I was able to solve the problem by using chown on the folder: sudo chown -R “$USER”:admin /usr/local Also you’ll (most probably) have to do the same on /Library/Caches/Homebrew: sudo chown -R “$USER”:admin /Library/Caches/Homebrew Apparently I had used sudo before in a way that altered my folder permission on /usr/local, from here on forward all … Read more

How can I start PostgreSQL server on Mac OS X?

The Homebrew package manager includes launchctl plists to start automatically. For more information, run brew info postgres. Start manually pg_ctl -D /usr/local/var/postgres start Stop manually pg_ctl -D /usr/local/var/postgres stop Start automatically “To have launchd start postgresql now and restart at login:” brew services start postgresql What is the result of pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log … Read more

Homebrew install specific version of formula?

TLDR: brew install postgresql@8.4.4 See answer below for more details. *(I’ve re-edited my answer to give a more thorough workflow for installing/using older software versions with homebrew. Feel free to add a note if you found the old version better.) Let’s start with the simplest case: 1) Check, whether the version is already installed (but … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)