{"action":"opened","issue":{"url":"https://api.github.com/repos/travis-ci/travis-ci/issues/6711","repository_url":"https://api.github.com/repos/travis-ci/travis-ci","labels_url":"https://api.github.com/repos/travis-ci/travis-ci/issues/6711/labels{/name}","comments_url":"https://api.github.com/repos/travis-ci/travis-ci/issues/6711/comments","events_url":"https://api.github.com/repos/travis-ci/travis-ci/issues/6711/events","html_url":"https://github.com/travis-ci/travis-ci/issues/6711","id":182347862,"number":6711,"title":"travis-ci.com dist trusty with postgis is failing to install with postgresql 9.5","user":{"login":"billxinli","id":1641464,"avatar_url":"https://avatars.githubusercontent.com/u/1641464?v=3","gravatar_id":"","url":"https://api.github.com/users/billxinli","html_url":"https://github.com/billxinli","followers_url":"https://api.github.com/users/billxinli/followers","following_url":"https://api.github.com/users/billxinli/following{/other_user}","gists_url":"https://api.github.com/users/billxinli/gists{/gist_id}","starred_url":"https://api.github.com/users/billxinli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/billxinli/subscriptions","organizations_url":"https://api.github.com/users/billxinli/orgs","repos_url":"https://api.github.com/users/billxinli/repos","events_url":"https://api.github.com/users/billxinli/events{/privacy}","received_events_url":"https://api.github.com/users/billxinli/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-10-11T19:07:59Z","updated_at":"2016-10-11T19:07:59Z","closed_at":null,"body":"I have a private repo that has `shp2pgsql` as a binary dependency which is installed from postgis, however postgis is conflicting with postgresql 9.5. The fix would be using postgresql 9.6, however travis is currently not supporting postgresql 9.6\r\n\r\n```\r\nlanguage: node_js\r\ndist: trusty\r\n\r\nnode_js:\r\n  - \"6.7.0\"\r\n\r\nservices:\r\n  - redis-server\r\n  - postgresql\r\n\r\nbefore_install:\r\n  - sudo apt-get update -qq\r\n  - sudo apt-get install -y libpixman-1-dev libcairo2-dev libpango1.0-dev libjpeg-dev libgif-dev graphicsmagick build-essential gcc g++ postgresql-9.5-postgis-2.2 postgresql-9.5-postgis-scripts postgis\r\n  - type shp2pgsql\r\n\r\nbefore_script:\r\n  - cp config/application.travis.js config/application.js\r\n  - psql -c 'CREATE DATABASE travis_ci_test;' -U postgres\r\n  - psql -c 'CREATE EXTENSION postgis;' -U postgres -d travis_ci_test\r\n  - psql -c 'CREATE EXTENSION postgis_topology;' -U postgres -d travis_ci_test\r\n  - NODE_ENV=test gulp db:migrate\r\n\r\ncompiler:\r\n  - gcc\r\n  - clang\r\nenv:\r\n  - CXX=g++-4.8\r\n\r\naddons:\r\n  postgresql: 9.5\r\n  apt:\r\n    sources:\r\n    - ubuntu-toolchain-r-test\r\n    - precise-pgdg-9.5\r\n    packages:\r\n    - gcc-4.8\r\n    - g++-4.8\r\n    - postgresql-9.5\r\n    - postgresql-contrib-9.5\r\n\r\ncache:\r\n  directories:\r\n    - node_modules\r\n    - bower_components\r\n```\r\n\r\n```\r\nRefused to start PostgreSQL 9.6, because PostgreSQL 9.5 is currently running! You should first stop 9.5 instance...\r\ninvoke-rc.d: initscript postgresql, action \"start\" failed.\r\ndpkg: error processing package postgresql-9.6 (--configure):\r\n subprocess installed post-installation script returned error exit status 13\r\ndpkg: dependency problems prevent configuration of postgresql-9.6-postgis-2.3:\r\n postgresql-9.6-postgis-2.3 depends on postgresql-9.6; however:\r\n  Package postgresql-9.6 is not configured yet.\r\ndpkg: error processing package postgresql-9.6-postgis-2.3 (--configure):\r\n dependency problems - leaving unconfigured\r\nSetting up postgresql-9.6-postgis-2.3-scripts (2.3.0+dfsg-2.pgdg14.04+1) ...\r\nNo apport report written because the error message indicates its a followup error from a previous failure.\r\ndpkg: dependency problems prevent configuration of postgresql-contrib-9.6:\r\n postgresql-contrib-9.6 depends on postgresql-9.6 (= 9.6.0-1.pgdg14.04+1); however:\r\n  Package postgresql-9.6 is not configured yet.\r\ndpkg: error processing package postgresql-contrib-9.6 (--configure):\r\n dependency problems - leaving unconfigured\r\nSetting up postgresql-9.5-postgis-scripts (2.3.0+dfsg-2.pgdg14.04+1) ...\r\nNo apport report written because the error message indicates its a followup error from a previous failure.\r\nProcessing triggers for libc-bin (2.19-0ubuntu6.9) ...\r\nErrors were encountered while processing:\r\n postgresql-9.6\r\n postgresql-9.6-postgis-2.3\r\n postgresql-contrib-9.6\r\nE: Sub-process /usr/bin/dpkg returned an error code (1)\r\nThe command \"sudo apt-get install -y libpixman-1-dev libcairo2-dev libpango1.0-dev libjpeg-dev libgif-dev graphicsmagick build-essential gcc g++ postgresql-9.5-postgis-2.2 postgresql-9.5-postgis-scripts postgis\" failed and exited with 100 during .\r\n```"}}
{"actor":{"display_login":"billxinli"}}