{"action":"created","issue":{"url":"https://api.github.com/repos/CPVprogrammer/update-synology-index/issues/5","repository_url":"https://api.github.com/repos/CPVprogrammer/update-synology-index","labels_url":"https://api.github.com/repos/CPVprogrammer/update-synology-index/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/CPVprogrammer/update-synology-index/issues/5/comments","events_url":"https://api.github.com/repos/CPVprogrammer/update-synology-index/issues/5/events","html_url":"https://github.com/CPVprogrammer/update-synology-index/issues/5","id":148904295,"number":5,"title":"DSM 6.0 Error - Peer Authentication failed for user \"postgres\"","user":{"login":"Goodbyemoff","id":18507299,"avatar_url":"https://avatars.githubusercontent.com/u/18507299?v=3","gravatar_id":"","url":"https://api.github.com/users/Goodbyemoff","html_url":"https://github.com/Goodbyemoff","followers_url":"https://api.github.com/users/Goodbyemoff/followers","following_url":"https://api.github.com/users/Goodbyemoff/following{/other_user}","gists_url":"https://api.github.com/users/Goodbyemoff/gists{/gist_id}","starred_url":"https://api.github.com/users/Goodbyemoff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Goodbyemoff/subscriptions","organizations_url":"https://api.github.com/users/Goodbyemoff/orgs","repos_url":"https://api.github.com/users/Goodbyemoff/repos","events_url":"https://api.github.com/users/Goodbyemoff/events{/privacy}","received_events_url":"https://api.github.com/users/Goodbyemoff/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-04-17T00:12:10Z","updated_at":"2016-04-18T11:58:28Z","closed_at":null,"body":"I am getting the following error trying to run the script on DSM 6.0\r\n\r\n```\r\npsql: FATAL: Peer authentication failed for user \"postgres\"\r\n/volume1/transfer/update-synoindex.sh: line 163: return: : numeric argument required\r\n```\r\n\r\nIt seems that it is failing to authenticate for some reason.\r\nI think it may be a setup issue. Do I need to change permissions for the user postgres?"},"comment":{"url":"https://api.github.com/repos/CPVprogrammer/update-synology-index/issues/comments/211347277","html_url":"https://github.com/CPVprogrammer/update-synology-index/issues/5#issuecomment-211347277","issue_url":"https://api.github.com/repos/CPVprogrammer/update-synology-index/issues/5","id":211347277,"user":{"login":"CPVprogrammer","id":10565295,"avatar_url":"https://avatars.githubusercontent.com/u/10565295?v=3","gravatar_id":"","url":"https://api.github.com/users/CPVprogrammer","html_url":"https://github.com/CPVprogrammer","followers_url":"https://api.github.com/users/CPVprogrammer/followers","following_url":"https://api.github.com/users/CPVprogrammer/following{/other_user}","gists_url":"https://api.github.com/users/CPVprogrammer/gists{/gist_id}","starred_url":"https://api.github.com/users/CPVprogrammer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CPVprogrammer/subscriptions","organizations_url":"https://api.github.com/users/CPVprogrammer/orgs","repos_url":"https://api.github.com/users/CPVprogrammer/repos","events_url":"https://api.github.com/users/CPVprogrammer/events{/privacy}","received_events_url":"https://api.github.com/users/CPVprogrammer/received_events","type":"User","site_admin":false},"created_at":"2016-04-18T11:58:28Z","updated_at":"2016-04-18T11:58:28Z","body":"I found this solution:\r\nhttp://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge\r\n\r\nin /etc/postgresql there is a file named \"pg_hba.conf\" and you can change the method with these:\r\n    trust - anyone who can connect to the server is authorized to access the database\r\n    peer - use client's operating system user name as database user name to access it.\r\n    md5 - password-base authentication\r\n\r\nI use root for execute the script and my \"pg_hba.conf\" file is:\r\n# TYPE  DATABASE        USER            ADDRESS                 METHOD\r\nlocal       all                       postgres                                          peer map=pg_root\r\nlocal       all                       all                                                    peer\r\n\r\nI hope this solution help you."}}