I have a production SQL dump file that I want to restore to my local psql db for debugging reasons.
I can't access psql via the terminal though pgAdmin3 works just fine. Here is the error I'm getting:
$ psql psql: could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"? $ locate psql | grep /bin /Library/PostgreSQL/9.0/bin/psql /Library/PostgreSQL/versions/9.0.1/bin/psql /opt/local/bin/psql83 /opt/local/lib/postgresql83/bin/psql /usr/bin/psql
I tried using sudo, no change. Any Idea why I can't connect w terminal on the mac and then restore the sql db dump locally?