{"action":"created","issue":{"url":"https://api.github.com/repos/sinalpha/sinalpha.github.io/issues/190","repository_url":"https://api.github.com/repos/sinalpha/sinalpha.github.io","labels_url":"https://api.github.com/repos/sinalpha/sinalpha.github.io/issues/190/labels{/name}","comments_url":"https://api.github.com/repos/sinalpha/sinalpha.github.io/issues/190/comments","events_url":"https://api.github.com/repos/sinalpha/sinalpha.github.io/issues/190/events","html_url":"https://github.com/sinalpha/sinalpha.github.io/issues/190","id":156757604,"number":190,"title":"psql","user":{"login":"sinalpha","id":4320960,"avatar_url":"https://avatars.githubusercontent.com/u/4320960?v=3","gravatar_id":"","url":"https://api.github.com/users/sinalpha","html_url":"https://github.com/sinalpha","followers_url":"https://api.github.com/users/sinalpha/followers","following_url":"https://api.github.com/users/sinalpha/following{/other_user}","gists_url":"https://api.github.com/users/sinalpha/gists{/gist_id}","starred_url":"https://api.github.com/users/sinalpha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sinalpha/subscriptions","organizations_url":"https://api.github.com/users/sinalpha/orgs","repos_url":"https://api.github.com/users/sinalpha/repos","events_url":"https://api.github.com/users/sinalpha/events{/privacy}","received_events_url":"https://api.github.com/users/sinalpha/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-05-25T13:57:41Z","updated_at":"2016-10-13T07:23:37Z","closed_at":null,"body":"[How to make psql to default to localhost?](http://askubuntu.com/questions/218009/how-to-make-psql-to-default-to-localhost)\r\n\r\n~~~shell\r\nexport PGHOST=\"192.168.1.25\"\r\n~~~\r\n\r\n~~~shell\r\n##  192.168.1.25: /var/lib/.../pg_hba.conf\r\n\r\nhost all all 192.168.1.1/24 trust\r\n~~~\r\n\r\n[Installing postgres gem when database is on a different server](http://stackoverflow.com/questions/12522878/installing-postgres-gem-when-database-is-on-a-different-server)\r\n\r\n~~~shell\r\nyum install postgresql-devel\r\n~~~"},"comment":{"url":"https://api.github.com/repos/sinalpha/sinalpha.github.io/issues/comments/253435320","html_url":"https://github.com/sinalpha/sinalpha.github.io/issues/190#issuecomment-253435320","issue_url":"https://api.github.com/repos/sinalpha/sinalpha.github.io/issues/190","id":253435320,"user":{"login":"sinalpha","id":4320960,"avatar_url":"https://avatars.githubusercontent.com/u/4320960?v=3","gravatar_id":"","url":"https://api.github.com/users/sinalpha","html_url":"https://github.com/sinalpha","followers_url":"https://api.github.com/users/sinalpha/followers","following_url":"https://api.github.com/users/sinalpha/following{/other_user}","gists_url":"https://api.github.com/users/sinalpha/gists{/gist_id}","starred_url":"https://api.github.com/users/sinalpha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sinalpha/subscriptions","organizations_url":"https://api.github.com/users/sinalpha/orgs","repos_url":"https://api.github.com/users/sinalpha/repos","events_url":"https://api.github.com/users/sinalpha/events{/privacy}","received_events_url":"https://api.github.com/users/sinalpha/received_events","type":"User","site_admin":false},"created_at":"2016-10-13T07:23:37Z","updated_at":"2016-10-13T07:23:37Z","body":"pg_restore: [tar archiver] could not find header for file \"toc.dat\" in tar archive\r\n\r\n```\r\ntar cf lol.tar /Path/to/*  # *\r\n```\r\n\r\nand i still  get a \"segmentation fault\" with pg_restore?\r\n\r\n```\r\nprobably 9.6 not compatiable with 9.3; whatever\r\n```"}}
{"actor":{"display_login":"sinalpha"}}