Databases
StackOverflow2013
Postsdbo
POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
    primarykey
    data
    text
    <p>I just upgraded my MacMini Server from Lion Server to Mountain Lion using OS X Server. I am having the same problem with PostgreSQL that I did last year when I first installed Lion Server.</p> <p>When I try to do any kind of PostgreSQL terminal command I get the following notorious error message that many have gotten over the years:</p> <pre><code>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"? </code></pre> <p>I was attempting to change the password for _postgres when I got the error. I tried several commands but got the same error. I just rebooted my server but no luck. I logged in as root to look at /var/pgsql_socket and the folder is empty. Folder /var/pgsql_socket_alt is also empty.</p> <p>I have checked online about this. However just about all of the solutions I have read, including on Stack Overflow, suggest a removal and reinstall of PostgreSQL. I do not know but this does not seem like a plausible option because several options on the Server App use PostgreSQL. I contacted Apple Enterprise Support (no agreement) and I was told that my issue would have to be solved by the developers which would cast $695.</p> <p>I have a website that is down right now because I cannot rebuild it. I don't know where to turn for help with this at this point. I will continue looking online to see if I can find something. However I hope that someone can give me an answer quick so I can rebuild my database.</p> <p><strong>Update: 12/13/2012 15:33 GMT-6</strong></p> <p>Here is my output for ps auwwx|grep postg:</p> <pre><code>_postgres 28123 0.0 0.1 2479696 7724 ?? Ss 3:01PM 0:00.04 /Applications/Server.app/Contents/ServerRoot/usr/bin/postgres_real -D /Library/Server/PostgreSQL For Server Services/Data -c listen_addresses= -c log_connections=on -c log_directory=/Library/Logs/PostgreSQL -c log_filename=PostgreSQL_Server_Services.log -c log_line_prefix=%t -c log_lock_waits=on -c log_statement=ddl -c logging_collector=on -c unix_socket_directory=/Library/Server/PostgreSQL For Server Services/Socket -c unix_socket_group=_postgres -c unix_socket_permissions=0770 server1 28216 0.0 0.0 2432768 620 s000 R+ 3:02PM 0:00.00 grep postg _postgres 28138 0.0 0.0 2439388 752 ?? Ss 3:01PM 0:00.01 postgres: stats collector process _postgres 28137 0.0 0.0 2479828 1968 ?? Ss 3:01PM 0:00.00 postgres: autovacuum launcher process _postgres 28136 0.0 0.0 2479696 544 ?? Ss 3:01PM 0:00.00 postgres: wal writer process _postgres 28135 0.0 0.0 2479696 732 ?? Ss 3:01PM 0:00.01 postgres: writer process _postgres 28134 0.0 0.0 2479696 592 ?? Ss 3:01PM 0:00.00 postgres: checkpointer process _postgres 28131 0.0 0.0 2439388 368 ?? Ss 3:01PM 0:00.00 postgres: logger process </code></pre> <p><strong>Update: 12/13/2012 18:10 GMT-6</strong></p> <p>After intense web searching this video was found. I was able to get PostgreSQL working and remove the error. I am able to connect using pgadmin and phppgadmin. I was about to go back to Lion Server because of sheer frustration. Now I will not have to.</p> <p><a href="http://www.youtube.com/watch?v=y1c7WFMMkZ4" rel="noreferrer">http://www.youtube.com/watch?v=y1c7WFMMkZ4</a></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPamela Cook - LightBe Corp
    1. USPamela Cook - LightBe Corp
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    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. POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
      1. USmanderson
      1. VTFavorite
    3. VO
      singulars
      1. POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYour issue boils down to the fact that the Mac OS X pre-installed version of PostgreSQL's `psql` is on your `PATH` before the version you installed. They look for the unix socket in different places. Either use tcp/ip by specifying `-h localhost` or preferably fix your `PATH` so the correct `psql` is found first. Apple's bizarre decision to not only bundle PostgreSQL, but mess with it so it put things in non-standard places is the root cause of this problem.
      singulars
      1. POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
      1. USCraig Ringer
    2. COThere is an ongoing issue in OSX, where the packagers decided to put the unix-domain socket at a different place than normal. Let me search ... BRB ... http://stackoverflow.com/a/8482546/905902
      singulars
      1. POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
      1. USwildplasser
    3. COI copied an old PATH in .bashrc. I have not installed another version of postgreSQL. Here is my PATH statement which includes code for RVM. If someone could tell me what to change it to I will do that. When I do which psql it is found in /usr/bin/psql. Thanks so much for all of you for your help. PATH="$PATH:$HOME/.rvm/bin:/usr/bin/psql:/usr/local:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" I am also searching for the socket file while logged in as root.
      singulars
      1. POSocket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)
      1. USPamela Cook - LightBe Corp
 

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