Trouble setting up Postgres

Question

So long story short I'm starting work on a project and I have a variety of things that I need to setup in order to get started. One of those being PostgreSQL. I'm trying to get it setup but I'm running into a few problems. I can get the server started but then when I go to set it up I get the following:

Lady: anthonygarand$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
server starting

Lady: anthonygarand$ psql template1
psql: 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"?

Any help would be much appreciated. I can provide more details if necessary. Just let me know.. I don't know much about this stuff.

Thanks!

wildplasser · Accepted Answer · 2011-09-07 19:21:35Z

1

Does the listen socket exist on your filesystem ? (maybe the unixdomein socket is located in a different directory ( /tmp/ ). There seem to be pre-packaged binaries with different locations for the listen socket.) If it exists at that location, you should check your postgres.conf and pg_hba.conf.

answered Sep 7, 2011 at 19:21

wildplasser

44.5k9 gold badges72 silver badges116 bronze badges

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

Collectives™ on Stack Overflow

Trouble setting up Postgres

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