I also had the mysterious /var/pgsql_socket_alt folder post-upgrade, but I just removed it and created /var/pgsql_socket as suggested by However, that wasn't the final solution. That was for Lion, but I was having same issues as the one in this thread after upgrading from 10.6.8 to Mountain Lion and having installed PostgreSQL via HomeBrew prior while on 10.6.8. There appears to be no /var/pgsql_socket/ directory, let alone the /var/pgsql_socket/.s.PGSQL.5432 socket file mentioned above!?! Maybe the install of Mountain Lion wiped that out? $ ls -l /var/ | grep pgĭrwxr-x- 2 _postgres _postgres 68 Jun 20 16:39 pgsql_socket_alt Rendered users/ within layouts/application (1.3ms) Meltemi 466 0.0 0.0 2443096 3728 ? S Wed12PM 0:00.85 /usr/local/bin/postgres -D /usr/local/varpostgres -r /usr/local/var/postgres/server.logĪnd it's responding to queries (both to a test db and the development db) from a local Rails app User Load (0.2ms) SELECT "users".* FROM "users" Is the server running locally and acceptingĬonnections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?īut Postgres is still clearly running: $ ps aux | grep postgres
Psql: could not connect to server: No such file or directory I am unable to connect (but was able to before pre-Mountain Lion): $ psql -U rails -d myapp_development
#Postgres app rails cant connect how to
I'm not a DBA, but hoping someone can tell me how to troubleshoot this. It was installed originally via Homebrew.
#Postgres app rails cant connect mac os x
Recently updated my machine from Mac OS X Lion (10.7.4) to Mountain Lion (10.8) and I think it borked my PostgreSQL installation.
0 kommentar(er)
