Last Updated: February 25, 2016
·
4.52K
· 11449

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

4 Responses
Add your response

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 ·