Postgresql 9.2.1.0 upgrade via OSX Homebrew
# Upgrading to postgresql 9.2.1.0 via homebrew and experiencing issues connecting to postgres via psql
sudo mkdir /var/pgsql_socket
sudo chown -R `whoami`:staff /var/pgsql_socket
# edit /usr/local/var/postgres/postgresql.conf as follows:
unix_socket_directory = '/var/pgsql_socket'
# restart postgresql