Postgres unable to connect Server

Postgres could not connect to Server

Before you came to this problem, I assume you backup your Postgres database already.

Recently I upgraded my Mac OS X 10.9 (Mavericks) to Mac OS X 10.10 (Yosemite). All is installations  process on new OS is working perfectly fine, and a lot for features on 10.10 is new to the dependencies of my previews web apps. WhenI tried to run one of my web-apps that was working previously on 10.9, it cannot connect the Posgtres DB to the Web App server. The errors goes like this

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

Then I tried to google around and found some answers which I tried to apply on my terminal.

One thing I tried was to make directory and check.

brew uninstall postgres
brew install postgres
sudo mkdir /var/pgsql_socket/
sudo ln -s /private/tmp/.s.PGSQL.5432 /var/psql_socket/
rm /usr/local/var/postgres/postmaster.pid
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

Try running postgres -D /usr/local/var/postgres — it will give you a much more verbose output if postgres fails to start.

In my case, running rm -rf /usr/local/var/postgres && initdb /usr/local/var/postgres -E utf8removed my old databases and then reinitialized the postgres db schema.

Check that the socket file exists.

Andre$ ls -l /tmp/.s.PGSQL.5432
srwxrwxrwx  1 tech3  wheel  0 Feb 23 16:26 /tmp/.s.PGSQL.5432
Andre$ grep unix_socket /usr/local/var/postgres/postgresql.conf
#unix_socket_directories = '/tmp' # comma-separated list of directories
#unix_socket_group = '' # (change requires restart)
#unix_socket_permissions = 0777 # begin with 0 to use octal notation

Then another thing was to unload plist file, remove pid and load back plist file.

launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
rm /usr/local/var/postgres/postmaster.pid
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

Additionally you have to check if you have the latest XCode ver 6.1.1 on your machine and also Command Line Tools for OS X 10.10 (Yosemite). Please refer to the link below – ciao!

https://developer.apple.com/downloads/index.action#

Leave a Reply

Your email address will not be published. Required fields are marked *

I accept that my given data and my IP address is sent to a server in the USA only for the purpose of spam prevention through the Akismet program.More information on Akismet and GDPR.

This site uses Akismet to reduce spam. Learn how your comment data is processed.