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?

Well aparently I needed to set the host with the -h flag, which to me point of view is just dumb! — maumercado, Aug 07 '11 at 00:28

score 2 · Answer 1 · edited May 23 '17 at 12:21

2

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

edited May 23 '17 at 12:21

Community

1
1

answered Nov 12 '11 at 18:33

Fgblanch

5,195
8
37
51

score 0 · Answer 2 · answered Jul 28 '12 at 19:19

0

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/).

answered Jul 28 '12 at 19:19

Daniil Ryzhkov

7,416
2
41
58

Postgresql macports cannot connect problem

2 Answers2