CODEWITHSUNDEEP
macospostgresqlmacports
maumercado
maumercado

Reputation: 1473

Postgresql macports cannot connect problem

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?

Upvotes: 5

Views: 3731

Answers (2)

Daniil Ryzhkov
Daniil Ryzhkov

Reputation: 7596

I solved this problem by changing DATABASES.HOST value to /tmp/ (for some reason after updating OS X to M-Lion postgresql changed socket folder to /tmp/).

Upvotes: 0

Fgblanch
Fgblanch

Reputation: 5295

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

Upvotes: 2

Related Questions