[Answer]-Postgresql socket error when running Django's syncdb (mac OS 10.7.5)

Found the answer courtesy of Bradley Ayers:

• set “unix_socket_directory” to “/var/pgsql_socket/” in postgres.conf
• executed following commands:
  • “$ sudo dscl . append /Groups/_postgres GroupMembership postgres”
  • “$ sudo chmod g+w,o+rx /var/pgsql_socket/”
• restarted postgresql

your database is not running try

pg_ctl -D /usr/local/var/postgres  start

assuming thats where your postgre data directory is