{"action":"created","issue":{"url":"https://api.github.com/repos/mysociety/mapit/issues/156","labels_url":"https://api.github.com/repos/mysociety/mapit/issues/156/labels{/name}","comments_url":"https://api.github.com/repos/mysociety/mapit/issues/156/comments","events_url":"https://api.github.com/repos/mysociety/mapit/issues/156/events","html_url":"https://github.com/mysociety/mapit/pull/156","id":53538317,"number":156,"title":"Use \"CREATE EXTENSION postgis; ...\" on Ubuntu trusty","user":{"login":"mhl","id":7907,"avatar_url":"https://avatars.githubusercontent.com/u/7907?v=3","gravatar_id":"","url":"https://api.github.com/users/mhl","html_url":"https://github.com/mhl","followers_url":"https://api.github.com/users/mhl/followers","following_url":"https://api.github.com/users/mhl/following{/other_user}","gists_url":"https://api.github.com/users/mhl/gists{/gist_id}","starred_url":"https://api.github.com/users/mhl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mhl/subscriptions","organizations_url":"https://api.github.com/users/mhl/orgs","repos_url":"https://api.github.com/users/mhl/repos","events_url":"https://api.github.com/users/mhl/events{/privacy}","received_events_url":"https://api.github.com/users/mhl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-01-06T17:19:22Z","updated_at":"2015-01-19T09:36:17Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mysociety/mapit/pulls/156","html_url":"https://github.com/mysociety/mapit/pull/156","diff_url":"https://github.com/mysociety/mapit/pull/156.diff","patch_url":"https://github.com/mysociety/mapit/pull/156.patch"},"body":"As described here:\r\n\r\n  https://docs.djangoproject.com/en/1.6/ref/contrib/gis/install/postgis/#creating-a-spatial-database-with-postgis-2-0-and-postgresql-9-1\r\n\r\n... creating a PostGIS database should be done with\r\n\"CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;\"\r\nwhere PostGIS and PostgreSQL are late enough versions, rather\r\nthan the script to create a template_postgis template.\r\n\r\nThe only supported distribution where we have these versions is\r\ncurrently Ubuntu trusty."},"comment":{"url":"https://api.github.com/repos/mysociety/mapit/issues/comments/70466681","html_url":"https://github.com/mysociety/mapit/pull/156#issuecomment-70466681","issue_url":"https://api.github.com/repos/mysociety/mapit/issues/156","id":70466681,"user":{"login":"stevenday","id":663700,"avatar_url":"https://avatars.githubusercontent.com/u/663700?v=3","gravatar_id":"","url":"https://api.github.com/users/stevenday","html_url":"https://github.com/stevenday","followers_url":"https://api.github.com/users/stevenday/followers","following_url":"https://api.github.com/users/stevenday/following{/other_user}","gists_url":"https://api.github.com/users/stevenday/gists{/gist_id}","starred_url":"https://api.github.com/users/stevenday/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stevenday/subscriptions","organizations_url":"https://api.github.com/users/stevenday/orgs","repos_url":"https://api.github.com/users/stevenday/repos","events_url":"https://api.github.com/users/stevenday/events{/privacy}","received_events_url":"https://api.github.com/users/stevenday/received_events","type":"User","site_admin":false},"created_at":"2015-01-19T09:36:17Z","updated_at":"2015-01-19T09:36:17Z","body":"Not sure if it will affect this or not, but FYI, it looks like Django 1.8 is going to call `CREATE EXTENSION postgis` automatically: https://docs.djangoproject.com/en/dev/releases/1.8/#django-contrib-gis"}}