For those of you using Homebrew and Homebrew installed PostgreSQL, here's a few notes on my Yosemite upgrade from over the weekend:
The installation process went smoothly right up until the end. With "3 minutes remaining" it appeared to stall. Be patient. In the background the installer is doing some weird copying routine of /usr/local. This took 4 hours on my machine. Hit Cmd-L to see the log of what's going on.
During the above mentioned copying routine of /usr/local, it seems to be skipping empty directories. Unfortunately PostgreSQL requires a few of these empty directories to be present to run properly. To fix this simply run: