Hello, I'm having trouble restarting the postgres server on my mac. The error I am getting when I try to run PG is:
could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Here's the command that I tried: sudo su postgres bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D /Library/PostgreSQL/9.1/data restart pg_ctl: PID file "/Library/PostgreSQL/9.1/data/postmaster.pid" does not exist Is server running? starting server anyway server starting then I checked the server status: bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D /Library/PostgreSQL/9.1/data status pg_ctl: no server running I verified that the pg_ctl and pg_conf files were in place. I then went ahead and tried this: bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D /Library/PostgreSQL/9.1/data start server starting then I checked the server status: bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D /Library/PostgreSQL/9.1/data status pg_ctl: no server running Why is the postgres not starting? I am doing all this under the postgres superuser, so I should not have any issue with user privileges. Thanks, Andrew
