postgresql create user on osx

Question

I'm on osx and I have problems creation of user postgresql. when I write the command:

createuser myapp -s

I get the following error:

could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

I do not know if it's just PATH directory problem.

PATH=$PATH:$HOME/.rvm/bin # Add RVM to PATH for scripting

I installed postgresql with this solution : http://tammersaleh.com/posts/installing-postgresql-for-rails-3-1-on-lion

thanks for your help and sorry for my bad english.

wollud1969 · Accepted Answer · 2012-09-03 10:57:32Z

1

Are you sure the postgres server is running? (Use "ps ax | grep postgres"). Has it opened a TCP port (per default 5432)? Is this unix socket "/var/pgsql_socket/.s.PGSQL.5432" available and do you have the permissions to read/write it?

Furthermore, you may want to check the pg_hba.conf file where the permissions on the postgres server itself are configured.

answered Sep 3, 2012 at 10:57

wollud1969

5075 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

postgresql create user on osx

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related