{"action":"created","issue":{"url":"https://api.github.com/repos/opscode-cookbooks/database/issues/97","labels_url":"https://api.github.com/repos/opscode-cookbooks/database/issues/97/labels{/name}","comments_url":"https://api.github.com/repos/opscode-cookbooks/database/issues/97/comments","events_url":"https://api.github.com/repos/opscode-cookbooks/database/issues/97/events","html_url":"https://github.com/opscode-cookbooks/database/pull/97","id":51425883,"number":97,"title":"Pgsql provider patches","user":{"login":"chr4","id":4600363,"avatar_url":"https://avatars.githubusercontent.com/u/4600363?v=3","gravatar_id":"","url":"https://api.github.com/users/chr4","html_url":"https://github.com/chr4","followers_url":"https://api.github.com/users/chr4/followers","following_url":"https://api.github.com/users/chr4/following{/other_user}","gists_url":"https://api.github.com/users/chr4/gists{/gist_id}","starred_url":"https://api.github.com/users/chr4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chr4/subscriptions","organizations_url":"https://api.github.com/users/chr4/orgs","repos_url":"https://api.github.com/users/chr4/repos","events_url":"https://api.github.com/users/chr4/events{/privacy}","received_events_url":"https://api.github.com/users/chr4/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2014-12-09T13:14:57Z","updated_at":"2015-08-20T13:49:57Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/opscode-cookbooks/database/pulls/97","html_url":"https://github.com/opscode-cookbooks/database/pull/97","diff_url":"https://github.com/opscode-cookbooks/database/pull/97.diff","patch_url":"https://github.com/opscode-cookbooks/database/pull/97.patch"},"body":"Trying a new pull-request as a desperation move, as the original https://github.com/opscode-cookbooks/database/pull/48 wasn't merged or declined since over one year :(\r\n\r\nThis is critical for me, and I suppose for other users, as the database cookbook doesn't allow to set e.g. `REPLICATION` permissions in the `postgresql_database_user` provider."},"comment":{"url":"https://api.github.com/repos/opscode-cookbooks/database/issues/comments/133013576","html_url":"https://github.com/opscode-cookbooks/database/pull/97#issuecomment-133013576","issue_url":"https://api.github.com/repos/opscode-cookbooks/database/issues/97","id":133013576,"user":{"login":"chr4","id":4600363,"avatar_url":"https://avatars.githubusercontent.com/u/4600363?v=3","gravatar_id":"","url":"https://api.github.com/users/chr4","html_url":"https://github.com/chr4","followers_url":"https://api.github.com/users/chr4/followers","following_url":"https://api.github.com/users/chr4/following{/other_user}","gists_url":"https://api.github.com/users/chr4/gists{/gist_id}","starred_url":"https://api.github.com/users/chr4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chr4/subscriptions","organizations_url":"https://api.github.com/users/chr4/orgs","repos_url":"https://api.github.com/users/chr4/repos","events_url":"https://api.github.com/users/chr4/events{/privacy}","received_events_url":"https://api.github.com/users/chr4/received_events","type":"User","site_admin":false},"created_at":"2015-08-20T13:49:57Z","updated_at":"2015-08-20T13:49:57Z","body":"I'm raising this again.\r\nSince postgresql-9.4 there are more issues coming up, e.g. creating a replication only user fails, because the cookbook is not using `pg_roles` to check whether a role exists, but `pg_users`. Since `9.4`, a role with `NOLOGIN, REPLICATION` is not listed in `pg_users` therefore raising:\r\n\r\n```\r\nPG::DuplicateObject\r\n    -------------------\r\n    ERROR:  role \"replication_user\" already exists\r\n```"}}