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