You had brewed PostgreSQL and can’t get it to start after the Yosemite upgrade? Check the logs and see if you get the following error.

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

If so, then you need to create a few directories that went missing as part of the upgrade.

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

After running the above commands try starting PostgreSQL and it should start. Thanks to this Stack Overflow post for the details.

Back to blog...