I recieve the mistake below when attempting to begin my rails application around the localhost:
PGError (couldn't connect with server: No such file or directory May be the server running in your area and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
From things i read it may sound such as this is probably an issue in hooking up towards the Postgres server, and could indicate that it's not began?
Everything began after i was trying my first (yay noobs!) merge using git. There is a conflict (getting related to the Rubymine workspace.xml file), and that i began to spread out up a conflict resolution program. After that it appeared that there is really you don't need to track workspace.xml whatsoever therefore i quit in the resolution program, planning to operate "git rm --cached" around the file. I believe in giving up this program something went foul, and that i wound up restarting, before untracking the file, after which finishing the merge. Further evidence that something was gummed up is the fact that my terminal spend did not open properly until I restarted the equipment.
Now, so far as I will tell, my way through the merge went fine (there have been trivial variations within the two branches anyway), as well as the existence of me I can not appear to eliminate this PGError. Whether it is actually beginning the server, then I'd love help regarding how to do this.
(other context: OSx, rails 3, posgresql83 installed via macports, pg jewel).
EDIT - I've been attempting to launch the server, but am not succeeding. e.g., I attempted:
pg_ctl start -D /opt/local/var/db/postgresql83/defaultdb
This appears to become your path for that data (it finds the postgresql.conf file) however the response I recieve is "cannot execute binary file."
and could indicate that it's not began?
Yes, seems like the server isn't running in your local machine.
Begin to see the description of the error within the PostgreSQL manual:
sudo port load postgresql83-server - this will use the most recent 8.3 port from macports.
If the does not work, try
sudo port selfupdate; sudo port upgrade outdated after which repeat the process.
Note - this might take absolutely age range.
To begin the server, try something across the following lines (adjust for pgsql version # and logfile):
sudo su postgres -c '/opt/local/lib/postgresql84/bin/pg_ctl -D /opt/local/var/db/postgresql8/defaultdb -l /opt/local/var/log/postgresql84/postgres.log start'
To prevent the server,
sudo su postgres -c '/opt/local/lib/postgresql84/bin/pg_ctl -D /opt/local/var/db/postgresql84/defaultdb stop'