Fixing postgres homebrew install after yosemite upgrade
for some reasons yosemite cleaned up some files/directories in /usr/local
for postgres installed via homebrew the following directories were missing to start postgres properly:
/usr/local/var/postgres/pg_tblspc
/usr/local/var/postgres/pg_twophase
/usr/local/var/postgres/pg_stat_tmp
Written by Andi
Related protips
4 Responses

Works great! In one command:
mkdir -p /usr/local/var/postgres/{pg_tblspc,pg_twophase,pg_stat_tmp}
over 1 year ago
·

Thanks for the info... plus, the one-liner worked like a charm.
over 1 year ago
·

Nice, that one-liner fixed the issue for me as well.
over 1 year ago
·

I was missing another directory, and the output from postgres -D /usr/local/var/postgres
told me which one it was.
over 1 year ago
·
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Postgres
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#