Databases
StackOverflow2013
Postsdbo
POPostgress Server error -> PGError: could not connect to server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPostgress Server error -> PGError: could not connect to server
    primarykey
    data
    text
    <p>I get the error below when trying to start my rails app on the localhost:</p> <blockquote> <p>PGError (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"?</p> </blockquote> <p>From what I have read it sounds like this is most likely a problem in connecting to the Postgres server, and may indicate that it is not started? </p> <p>It all started when I was attempting my first (yay noobs!) merge using git. There was a conflict (having to do with the Rubymine workspace.xml file), and I started to open up a conflict resolution program. It then seemed that there was really no need to track workspace.xml at all and so I quit from the resolution program, intending to run "git rm --cached" on the file. I think in quitting the program something went foul, and I ended up restarting, before untracking the file, and then completing the merge. Further evidence that something was gummed up is that my terminal shell didn't open up correctly until I restarted the machine. </p> <p>Now, as far as I can tell, everything in the merge went fine (there were trivial differences in the two branches anyway), but for the life of me I can't seem to get rid of this PGError. If it is as simple as starting the server, then I'd love help on how to do that. </p> <p>Help!</p> <p>Thanks. </p> <p>(other context: OSx, rails 3, posgresql83 installed via macports, pg gem). </p> <p>EDIT - I have been trying to start up the server, but am not succeeding. e.g., I tried: </p> <pre><code>pg_ctl start -D /opt/local/var/db/postgresql83/defaultdb </code></pre> <p>This seems to be the right path for the data (it finds the postgresql.conf file) but the response I get is "cannot execute binary file." </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPhil_Ken_Sebben
    1. USPhil_Ken_Sebben
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPostgress Server error -> PGError: could not connect to server
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload