{"action":"created","issue":{"url":"https://api.github.com/repos/parallels-cookbooks/confluence/issues/54","labels_url":"https://api.github.com/repos/parallels-cookbooks/confluence/issues/54/labels{/name}","comments_url":"https://api.github.com/repos/parallels-cookbooks/confluence/issues/54/comments","events_url":"https://api.github.com/repos/parallels-cookbooks/confluence/issues/54/events","html_url":"https://github.com/parallels-cookbooks/confluence/pull/54","id":108775577,"number":54,"title":"Set postgres db owner to confluence user.","user":{"login":"patcon","id":305339,"avatar_url":"https://avatars.githubusercontent.com/u/305339?v=3","gravatar_id":"","url":"https://api.github.com/users/patcon","html_url":"https://github.com/patcon","followers_url":"https://api.github.com/users/patcon/followers","following_url":"https://api.github.com/users/patcon/following{/other_user}","gists_url":"https://api.github.com/users/patcon/gists{/gist_id}","starred_url":"https://api.github.com/users/patcon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/patcon/subscriptions","organizations_url":"https://api.github.com/users/patcon/orgs","repos_url":"https://api.github.com/users/patcon/repos","events_url":"https://api.github.com/users/patcon/events{/privacy}","received_events_url":"https://api.github.com/users/patcon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/parallels-cookbooks/confluence/milestones/1","html_url":"https://github.com/parallels-cookbooks/confluence/milestones/2.0.0","labels_url":"https://api.github.com/repos/parallels-cookbooks/confluence/milestones/1/labels","id":1349256,"number":1,"title":"2.0.0","description":null,"creator":{"login":"legal90","id":4846154,"avatar_url":"https://avatars.githubusercontent.com/u/4846154?v=3","gravatar_id":"","url":"https://api.github.com/users/legal90","html_url":"https://github.com/legal90","followers_url":"https://api.github.com/users/legal90/followers","following_url":"https://api.github.com/users/legal90/following{/other_user}","gists_url":"https://api.github.com/users/legal90/gists{/gist_id}","starred_url":"https://api.github.com/users/legal90/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/legal90/subscriptions","organizations_url":"https://api.github.com/users/legal90/orgs","repos_url":"https://api.github.com/users/legal90/repos","events_url":"https://api.github.com/users/legal90/events{/privacy}","received_events_url":"https://api.github.com/users/legal90/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":3,"state":"open","created_at":"2015-10-11T12:42:28Z","updated_at":"2015-11-12T10:42:52Z","due_on":null,"closed_at":null},"comments":9,"created_at":"2015-09-29T01:03:32Z","updated_at":"2015-11-12T14:45:41Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/parallels-cookbooks/confluence/pulls/54","html_url":"https://github.com/parallels-cookbooks/confluence/pull/54","diff_url":"https://github.com/parallels-cookbooks/confluence/pull/54.diff","patch_url":"https://github.com/parallels-cookbooks/confluence/pull/54.patch"},"body":"* This allows a database to be imported using a more flexible backup,\n  taken with the `--no-owner` flag. However, in order for the new\ndatabase to work as expected, the database my be owned by the user\nexpected to interact with it. This way, the table ownership is\nautomatically set to this db user during import, and this db user can\ncontinue to access later."},"comment":{"url":"https://api.github.com/repos/parallels-cookbooks/confluence/issues/comments/156122289","html_url":"https://github.com/parallels-cookbooks/confluence/pull/54#issuecomment-156122289","issue_url":"https://api.github.com/repos/parallels-cookbooks/confluence/issues/54","id":156122289,"user":{"login":"legal90","id":4846154,"avatar_url":"https://avatars.githubusercontent.com/u/4846154?v=3","gravatar_id":"","url":"https://api.github.com/users/legal90","html_url":"https://github.com/legal90","followers_url":"https://api.github.com/users/legal90/followers","following_url":"https://api.github.com/users/legal90/following{/other_user}","gists_url":"https://api.github.com/users/legal90/gists{/gist_id}","starred_url":"https://api.github.com/users/legal90/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/legal90/subscriptions","organizations_url":"https://api.github.com/users/legal90/orgs","repos_url":"https://api.github.com/users/legal90/repos","events_url":"https://api.github.com/users/legal90/events{/privacy}","received_events_url":"https://api.github.com/users/legal90/received_events","type":"User","site_admin":false},"created_at":"2015-11-12T14:45:41Z","updated_at":"2015-11-12T14:45:41Z","body":"@patcon Thank you! Now it's clear for me :)\r\n\r\nBut yes, this PR should be modified, because user should be already created when we try to create a DB. Otherwise, there will be an error like this:\r\n\r\n```\r\n       Recipe: confluence::database\r\n\r\n\r\n           ================================================================================\r\n           Error executing action `create` on resource 'postgresql_database[confluence]'\r\n           ================================================================================\r\n\r\n           PG::UndefinedObject\r\n           -------------------\r\n           ERROR:  role \"confluence\" does not exist\r\n```"}}