PostgreSQL fix for OS X Yosemite

commands

# Uninstall old postgresql installation from your system and then install via homebrew the new one
brew unlink postgresql
brew install postgresql

# Create postgresql missing directories
mkdir /usr/local/var/postgres/pg_tblspc
mkdir /usr/local/var/postgres/pg_twophase
mkdir /usr/local/var/postgres/pg_stat_tmp