{"action":"created","issue":{"url":"https://api.github.com/repos/PostgresApp/PostgresApp/issues/331","repository_url":"https://api.github.com/repos/PostgresApp/PostgresApp","labels_url":"https://api.github.com/repos/PostgresApp/PostgresApp/issues/331/labels{/name}","comments_url":"https://api.github.com/repos/PostgresApp/PostgresApp/issues/331/comments","events_url":"https://api.github.com/repos/PostgresApp/PostgresApp/issues/331/events","html_url":"https://github.com/PostgresApp/PostgresApp/issues/331","id":164225992,"number":331,"title":"Could not translate host name \"localhost\", service \"5432\" to address: nodename nor servname provided, or not known","user":{"login":"luminousbeam","id":9014849,"avatar_url":"https://avatars.githubusercontent.com/u/9014849?v=3","gravatar_id":"","url":"https://api.github.com/users/luminousbeam","html_url":"https://github.com/luminousbeam","followers_url":"https://api.github.com/users/luminousbeam/followers","following_url":"https://api.github.com/users/luminousbeam/following{/other_user}","gists_url":"https://api.github.com/users/luminousbeam/gists{/gist_id}","starred_url":"https://api.github.com/users/luminousbeam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luminousbeam/subscriptions","organizations_url":"https://api.github.com/users/luminousbeam/orgs","repos_url":"https://api.github.com/users/luminousbeam/repos","events_url":"https://api.github.com/users/luminousbeam/events{/privacy}","received_events_url":"https://api.github.com/users/luminousbeam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-07-07T04:11:29Z","updated_at":"2016-07-07T14:37:44Z","closed_at":null,"body":"This is my first time installing Postgresql on this machine, I am using a MacBook Pro, OSX El Capitan v 10.11.5. I am trying to run a Rails application (https://github.com/ga-wdi-exercises/tunr_rails_json) but keep getting that log message:\r\n`Could not translate host name \"localhost\", service \"5432\" to address: nodename nor servname provided, or not known`\r\n\r\n...every time I try to run this command:\r\n`rake db:setup`\r\n\r\nI also get this error message on my terminal:\r\n\r\n`Couldn't create database for {\"adapter\"=>\"postgresql\", \"encoding\"=>\"unicode\", \"pool\"=>5, \"database\"=>\"tunr_test\"}\r\n** Invoke environment (first_time)\r\n** Execute environment\r\n** Execute db:schema:load_if_ruby\r\n** Invoke db:schema:load (first_time)\r\n** Invoke db:load_config\r\n** Execute db:schema:load\r\n-- enable_extension(\"plpgsql\")\r\nrake aborted!\r\nPG::ConnectionBad: could not connect to server: No such file or directory\r\n\tIs the server running locally and accepting\r\n\tconnections on Unix domain socket \"/tmp/.s.PGSQL.5432\"?`\r\n\r\nI have read the git issue #200 and #152 but was not able to get this up and running after trying to uninstall and install Postgresql several times...I am not wiping my whole system clean and re-installing my OSX like someone else there suggested, I am using a work laptop.\r\n\r\n`ping localhost`\r\n\r\nreturns:\r\n`ping: cannot resolve localhost: Unknown host`\r\n\r\n`dig localhost` \r\n\r\nreturns:\r\n; <<>> DiG 9.8.3-P1 <<>> localhost\r\n;; global options: +cmd\r\n;; Got answer:\r\n;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 59944\r\n;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 1, ADDITIONAL: 1\r\n\r\n;; QUESTION SECTION:\r\n;localhost.\t\t\tIN\tA\r\n\r\n;; ANSWER SECTION:\r\nlocalhost.\t\t604800\tIN\tA\t127.0.0.1\r\n\r\n;; AUTHORITY SECTION:\r\nlocalhost.\t\t604800\tIN\tNS\tlocalhost.\r\n\r\n;; ADDITIONAL SECTION:\r\nlocalhost.\t\t604800\tIN\tAAAA\t::1\r\n\r\n;; Query time: 7 msec\r\n;; SERVER: 192.168.1.1#53(192.168.1.1)\r\n;; WHEN: Thu Jul  7 00:13:55 2016\r\n;; MSG SIZE  rcvd: 85\r\n\r\n`scutil -r localhost`\r\n`Reachable`"},"comment":{"url":"https://api.github.com/repos/PostgresApp/PostgresApp/issues/comments/231097327","html_url":"https://github.com/PostgresApp/PostgresApp/issues/331#issuecomment-231097327","issue_url":"https://api.github.com/repos/PostgresApp/PostgresApp/issues/331","id":231097327,"user":{"login":"jakob","id":198305,"avatar_url":"https://avatars.githubusercontent.com/u/198305?v=3","gravatar_id":"","url":"https://api.github.com/users/jakob","html_url":"https://github.com/jakob","followers_url":"https://api.github.com/users/jakob/followers","following_url":"https://api.github.com/users/jakob/following{/other_user}","gists_url":"https://api.github.com/users/jakob/gists{/gist_id}","starred_url":"https://api.github.com/users/jakob/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakob/subscriptions","organizations_url":"https://api.github.com/users/jakob/orgs","repos_url":"https://api.github.com/users/jakob/repos","events_url":"https://api.github.com/users/jakob/events{/privacy}","received_events_url":"https://api.github.com/users/jakob/received_events","type":"User","site_admin":false},"created_at":"2016-07-07T14:37:44Z","updated_at":"2016-07-07T14:37:44Z","body":"It sounds like the old server is still running. Quit Postgres.app, reboot your computer, then check in activity monitor if there are any processes named `postgres`. If there are, [please uninstall them](http://postgresapp.com/documentation/remove.html). Once you are sure that no PostgreSQL server is running on your Mac, start Postgres.app again.\r\n\r\nThen make sure that the \"Open psql\" command works. If you keep getting the error that the db doesn't exist, quit Postgres.app, then delete the data directory (in `~/Library/Application Support/Postgres/`), then restart Postgres.app.\r\n\r\nFinally, make sure that you [configured your path correctly](http://postgresapp.com/documentation/cli-tools.html) (typing `which psql` should echo `/Applications/Postgres.app/Contents/Versions/latest/bin/psql`)."}}
{"actor":{"display_login":"jakob"}}