{"action":"created","issue":{"url":"https://api.github.com/repos/Codaisseur/alea/issues/9","repository_url":"https://api.github.com/repos/Codaisseur/alea","labels_url":"https://api.github.com/repos/Codaisseur/alea/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/Codaisseur/alea/issues/9/comments","events_url":"https://api.github.com/repos/Codaisseur/alea/issues/9/events","html_url":"https://github.com/Codaisseur/alea/issues/9","id":192530348,"number":9,"title":"Recreate Postgres Cluster based on Stolon","user":{"login":"foxycoder","id":309331,"avatar_url":"https://avatars.githubusercontent.com/u/309331?v=3","gravatar_id":"","url":"https://api.github.com/users/foxycoder","html_url":"https://github.com/foxycoder","followers_url":"https://api.github.com/users/foxycoder/followers","following_url":"https://api.github.com/users/foxycoder/following{/other_user}","gists_url":"https://api.github.com/users/foxycoder/gists{/gist_id}","starred_url":"https://api.github.com/users/foxycoder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/foxycoder/subscriptions","organizations_url":"https://api.github.com/users/foxycoder/orgs","repos_url":"https://api.github.com/users/foxycoder/repos","events_url":"https://api.github.com/users/foxycoder/events{/privacy}","received_events_url":"https://api.github.com/users/foxycoder/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"michfarr","id":18257719,"avatar_url":"https://avatars.githubusercontent.com/u/18257719?v=3","gravatar_id":"","url":"https://api.github.com/users/michfarr","html_url":"https://github.com/michfarr","followers_url":"https://api.github.com/users/michfarr/followers","following_url":"https://api.github.com/users/michfarr/following{/other_user}","gists_url":"https://api.github.com/users/michfarr/gists{/gist_id}","starred_url":"https://api.github.com/users/michfarr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michfarr/subscriptions","organizations_url":"https://api.github.com/users/michfarr/orgs","repos_url":"https://api.github.com/users/michfarr/repos","events_url":"https://api.github.com/users/michfarr/events{/privacy}","received_events_url":"https://api.github.com/users/michfarr/received_events","type":"User","site_admin":false},"assignees":[{"login":"michfarr","id":18257719,"avatar_url":"https://avatars.githubusercontent.com/u/18257719?v=3","gravatar_id":"","url":"https://api.github.com/users/michfarr","html_url":"https://github.com/michfarr","followers_url":"https://api.github.com/users/michfarr/followers","following_url":"https://api.github.com/users/michfarr/following{/other_user}","gists_url":"https://api.github.com/users/michfarr/gists{/gist_id}","starred_url":"https://api.github.com/users/michfarr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michfarr/subscriptions","organizations_url":"https://api.github.com/users/michfarr/orgs","repos_url":"https://api.github.com/users/michfarr/repos","events_url":"https://api.github.com/users/michfarr/events{/privacy}","received_events_url":"https://api.github.com/users/michfarr/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-11-30T10:35:50Z","updated_at":"2016-12-01T09:11:03Z","closed_at":null,"body":"Replace the current Postgres+Pgpool-II setup with Stolon.\r\n\r\n### Some Background, Rationale\r\n\r\nThe current setup with pgpool does not work. When we create new postgres users for apps in the Services API, pgpool-II does not know about them and connection attempts with these new users fail with:\r\n\r\n```\r\nERROR:  \"MD5\" authentication with pgpool failed for user XXX\r\n```\r\n\r\nWe've used [Stolon][stolon] previously, and with success. However, with Stolon we are limited to just 100 client connections, hence the decision to use pgpool-II for connection pooling. With the headaches above as a result.\r\n\r\nSo, back to Stolon seems the most viable option right now. If we run out of connection slots, we could set up additional Stolon clusters in the future and link the Services API to that new one so it will start giving out databases and users on that new cluster. - Let's make that nice-to-have for now though.\r\n\r\n[stolon]: https://github.com/sorintlab/stolon/tree/master/examples/kubernetes"},"comment":{"url":"https://api.github.com/repos/Codaisseur/alea/issues/comments/264119595","html_url":"https://github.com/Codaisseur/alea/issues/9#issuecomment-264119595","issue_url":"https://api.github.com/repos/Codaisseur/alea/issues/9","id":264119595,"user":{"login":"michfarr","id":18257719,"avatar_url":"https://avatars.githubusercontent.com/u/18257719?v=3","gravatar_id":"","url":"https://api.github.com/users/michfarr","html_url":"https://github.com/michfarr","followers_url":"https://api.github.com/users/michfarr/followers","following_url":"https://api.github.com/users/michfarr/following{/other_user}","gists_url":"https://api.github.com/users/michfarr/gists{/gist_id}","starred_url":"https://api.github.com/users/michfarr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michfarr/subscriptions","organizations_url":"https://api.github.com/users/michfarr/orgs","repos_url":"https://api.github.com/users/michfarr/repos","events_url":"https://api.github.com/users/michfarr/events{/privacy}","received_events_url":"https://api.github.com/users/michfarr/received_events","type":"User","site_admin":false},"created_at":"2016-12-01T09:11:03Z","updated_at":"2016-12-01T09:11:03Z","body":"PR opened: #10 "}}
{"actor":{"display_login":"michfarr"}}