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
– maumercado, Commented Aug 7, 2011 at 0:28

Community · Accepted Answer · 2017-05-23 12:21:11Z

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, 2017 at 12:21

CommunityBot

11 silver badge

answered Nov 12, 2011 at 18:33

Fgblanch

5,3059 gold badges39 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniil Ryzhkov · Accepted Answer · 2012-07-28 19:19:47Z

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, 2012 at 19:19

Daniil Ryzhkov

7,6264 gold badges44 silver badges59 bronze badges

Collectives™ on Stack Overflow

Postgresql macports cannot connect problem

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related