I recently upgraded to Yosemite after skip the reminder each day for the last year…

Everything was fine, Mysql working, brew packages are OK, rbenv, ruby and Rails stuff looks fine except Postgres.

Checking the logs I saw:

1

FATAL:  could not open directory "pg_tblspc": No such file or directory

The solution was easy:

1
2

cd /usr/local/var/postgres
mkdir pg_tblspc pg_twophase pg_stat_tmp