{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/13981","repository_url":"https://api.github.com/repos/CartoDB/cartodb","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/13981/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/13981/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/13981/events","html_url":"https://github.com/CartoDB/cartodb/pull/13981","id":324976205,"number":13981,"title":"CARTO now requires PostgreSQL 9.6","user":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars2.githubusercontent.com/u/932968?v=4","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars2.githubusercontent.com/u/932968?v=4","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"assignees":[{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars2.githubusercontent.com/u/932968?v=4","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-05-21T16:20:09Z","updated_at":"2018-05-22T09:54:33Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/CartoDB/cartodb/pulls/13981","html_url":"https://github.com/CartoDB/cartodb/pull/13981","diff_url":"https://github.com/CartoDB/cartodb/pull/13981.diff","patch_url":"https://github.com/CartoDB/cartodb/pull/13981.patch"},"body":"As detected [at this email list thread](https://groups.google.com/forum/#!topic/cartodb/TxB7pS_Nr9s), CARTO now requires PostgreSQL 9.6. It's caused by the need of `extensions` option at `postgres_fdw`, which [was added in 9.6](https://www.postgresql.org/docs/9.6/static/postgres-fdw.html) (check [9.5](https://www.postgresql.org/docs/9.5/static/postgres-fdw.html)). Our servers are running [a patch](https://commitfest.postgresql.org/7/304/) that was applied in 9.6.\r\n\r\nThis is just documentation. cc-ing @javitonino and @jvillarf for awareness. I'll merge on your agreement. Many thanks to @ibrahimmenem , who helped confirming this and the version at the servers."},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/390933004","html_url":"https://github.com/CartoDB/cartodb/pull/13981#issuecomment-390933004","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/13981","id":390933004,"user":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars2.githubusercontent.com/u/932968?v=4","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"created_at":"2018-05-22T09:54:33Z","updated_at":"2018-05-22T09:54:33Z","author_association":"CONTRIBUTOR","body":"The first branch at postgres-debian that I see with the patch\n<https://github.com/CartoDB/postgresql-debian/blob/9.5.7-cdb1_xenial/debian/patches/91-extension_shipping.patch>\nis 9.5.7-cdb1_xenial\n<https://github.com/CartoDB/postgresql-debian/tree/9.5.7-cdb1_xenial/debian/patches>.\n9.5-cdb doesn't have it\n<https://github.com/CartoDB/postgresql-debian/tree/9.5-cdb/debian/patches>.\n\nAccording to Launchpad, 9.5 corresponds to 9.5-cdb\n<https://launchpad.net/~cartodb/+archive/ubuntu/postgresql-9.5>. If I'm\nright, 9.5 doesn't have it, then.\n\nWhat do you think?\n\nOn Tue, May 22, 2018 at 7:40 AM, jvillarf <notifications@github.com> wrote:\n\n> Considering that all our databases will be postgres 10 by mid June, i'd\n> bump to postgres 10 as well. I agree with @javitonino\n> <https://github.com/javitonino> that we should check if our PPA postgres\n> 9.5 has that patches already, since we are encouraging to install such\n> package.\n>\n> Thanks for being so proactive @juanignaciosl\n> <https://github.com/juanignaciosl>\n>\n> —\n> You are receiving this because you were mentioned.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/CartoDB/cartodb/pull/13981#issuecomment-390869212>,\n> or mute the thread\n> <https://github.com/notifications/unsubscribe-auth/AA48aF_0Lf1UsHhLIhD596M7uzkCVh1mks5t06TEgaJpZM4UHQFa>\n> .\n>\n\n\n\n-- \n*Juan Ignacio Sánchez Lara*\nCARTO Backend Tech Lead\nTwitter: @juanignaciosl <https://twitter.com/juanignaciosl>\n\n*CARTO <http://www.carto.com> — Predict Through Location*\n\nLive sessions to learn CARTO <http://carto.com/webinars/>\n"}}
{"actor":{"display_login":"juanignaciosl"}}