PostgreSQL Socket Error after Installation

Question

I installed PostgreSQL(9.0.7) from EnterpriseDB on OS X 10.6. However, when I do a simple

$ psql -U postgres

I get this

psql: 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 am using it with Django. I tried changing the host variable in settings.py to

'HOST': '/tmp'

but I am still getting the same error message when I do a syndb. Any ideas? Thank you.

In my postgresql.conf

listen_addresses = '*'      
port = 5432             
unix_socket_directory = '/var/pgsql_socket/'

Edit: I got it working. For some reason installed the newer version 9.1.3 and that error went away. I also got some help from a cheat sheet for PostgreSQL(http://od-eon.com/blogs/calvin/postgresql-cheat-sheet-beginners/)

Jim · Accepted Answer · 2012-04-19 18:41:47Z

1

Have you started the database cluster? You should be able to tell by running the command

ps auwwx|grep postg

You should see several postgresql processes. If you do not, you need to start the database server.

http://www.postgresql.org/docs/9.0/static/server-start.html

answered Apr 19, 2012 at 18:41

Jim

4752 silver badges7 bronze badges

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

2 Comments

Zach Over a year ago

When I tried to start it I got this message The server must be started by the user that owns the data directory.

kgrittn Over a year ago

@Zach: See what OS user owns the data directory and start it as that user. There should be a service script which already does that, if you have rights to run service scripts.

Collectives™ on Stack Overflow

PostgreSQL Socket Error after Installation

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related