Postgresql macports cannot connect problem

Question

Im trying to run createuser command on a recently installed postgresql90-server instance with macports and Im getting this error.

createuser: could not connect to database postgres: 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"?

never the less If I run psql it connects to the database with no problem, what could be the problem?

Answer 1

This seems to be a problem with Lion because it (or maybe xcode) comes with a version of postgreSQL installed on it.

You can find the solution in this other post:

Repairing Postgresql after upgrading to OSX 10.7 Lion