I've been trying to set up PostgreSQL on my system (OSX 10.8, clean install), but I'm running into trouble with using psql, createdb, etc. I've tried various solutions and none seem to work.
The install was successful, and I proceeded to fix the known sockets issue using the following:
mkdir /var/pgsql_socket
sudo chown $USER /var/pgsql_socket
Then I edited postgresql.conf, set unix_socket_directory to
unix_socket_directory = '/var/pgsql_socket'
and restarted Pg.
That should apparently have fixed the socket issue, but I'm still getting:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Also, I've checked the status of the server, and it appears to be running, but I still get 'no such file or directory'
Any ideas?