{"action":"created","issue":{"url":"https://api.github.com/repos/freelawproject/courtlistener/issues/890","repository_url":"https://api.github.com/repos/freelawproject/courtlistener","labels_url":"https://api.github.com/repos/freelawproject/courtlistener/issues/890/labels{/name}","comments_url":"https://api.github.com/repos/freelawproject/courtlistener/issues/890/comments","events_url":"https://api.github.com/repos/freelawproject/courtlistener/issues/890/events","html_url":"https://github.com/freelawproject/courtlistener/issues/890","id":373713544,"node_id":"MDU6SXNzdWUzNzM3MTM1NDQ=","number":890,"title":"Upgrade postgres to latest feasible version","user":{"login":"mlissner","id":236970,"node_id":"MDQ6VXNlcjIzNjk3MA==","avatar_url":"https://avatars3.githubusercontent.com/u/236970?v=4","gravatar_id":"","url":"https://api.github.com/users/mlissner","html_url":"https://github.com/mlissner","followers_url":"https://api.github.com/users/mlissner/followers","following_url":"https://api.github.com/users/mlissner/following{/other_user}","gists_url":"https://api.github.com/users/mlissner/gists{/gist_id}","starred_url":"https://api.github.com/users/mlissner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mlissner/subscriptions","organizations_url":"https://api.github.com/users/mlissner/orgs","repos_url":"https://api.github.com/users/mlissner/repos","events_url":"https://api.github.com/users/mlissner/events{/privacy}","received_events_url":"https://api.github.com/users/mlissner/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":13,"created_at":"2018-10-24T23:17:32Z","updated_at":"2018-10-27T00:31:06Z","closed_at":null,"author_association":"MEMBER","body":"We're currently using postgres 9.3, but for a client we want to use AWS's migration/replication feature over at:\r\n\r\nhttps://aws.amazon.com/dms/\r\n\r\n(They want to have unfettered access to our latest DB.)\r\n\r\nThat requires that we have at least version 9.4, so we have to at least upgrade to that. \r\n\r\nThe Postgres folks kindly have an apt repository that supports our version of Ubuntu, so this shouldn't actually be too terrible. Last time we did this, we documented our work over here: https://github.com/freelawproject/courtlistener/issues/288\r\n\r\nA couple questions, though:\r\n\r\n1. Is there any reason not to upgrade all the way to the latest version? \r\n1. Do we need to run `pg_upgradecluster` for every point version we want to upgrade, or can we just do it once and skip a bunch of steps?\r\n1. How much downtime can we expect for this? \r\n\r\n"},"comment":{"url":"https://api.github.com/repos/freelawproject/courtlistener/issues/comments/433575884","html_url":"https://github.com/freelawproject/courtlistener/issues/890#issuecomment-433575884","issue_url":"https://api.github.com/repos/freelawproject/courtlistener/issues/890","id":433575884,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMzU3NTg4NA==","user":{"login":"mlissner","id":236970,"node_id":"MDQ6VXNlcjIzNjk3MA==","avatar_url":"https://avatars3.githubusercontent.com/u/236970?v=4","gravatar_id":"","url":"https://api.github.com/users/mlissner","html_url":"https://github.com/mlissner","followers_url":"https://api.github.com/users/mlissner/followers","following_url":"https://api.github.com/users/mlissner/following{/other_user}","gists_url":"https://api.github.com/users/mlissner/gists{/gist_id}","starred_url":"https://api.github.com/users/mlissner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mlissner/subscriptions","organizations_url":"https://api.github.com/users/mlissner/orgs","repos_url":"https://api.github.com/users/mlissner/repos","events_url":"https://api.github.com/users/mlissner/events{/privacy}","received_events_url":"https://api.github.com/users/mlissner/received_events","type":"User","site_admin":false},"created_at":"2018-10-27T00:31:06Z","updated_at":"2018-10-27T00:31:06Z","author_association":"MEMBER","body":"@jayed, that's a super generous offer! How the heck did you find this issue!? I'm planning on doing this upgrade tomorrow and I'd love any help I could get between now and then. I think it should go smoothly, but it would be great to have a quick chat to confirm things. I'm not much of a DBA, in case my logs here haven't made that clear..."}}
{"actor":{"display_login":"mlissner"}}