# Shamelessly ripped from plv8 repo before_install: - psql --version - python --version - sudo /etc/init.d/postgresql stop - sudo apt-get -y --purge remove postgresql libpq-dev libpq5 postgresql-client-common postgresql-common - sudo rm -rf /var/lib/postgresql - wget --no-check-certificate --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - - sudo sh -c "echo deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main $PGVERSION >> /etc/apt/sources.list.d/postgresql.list" - sudo apt-get update -qq - sudo apt-get -y -o Dpkg::Options::=--force-confdef -o Dpkg::Options::="--force-confnew" install postgresql-common - sudo sh -c "echo create_main_cluster = false >> /etc/postgresql-common/createcluster.conf" - sudo apt-get -y -o Dpkg::Options::=--force-confdef -o Dpkg::Options::="--force-confnew" install postgresql-$PGVERSION postgresql-server-dev-$PGVERSION postgresql-contrib-$PGVERSION - sudo add-apt-repository ppa:ubuntu-toolchain-r/test -y - sudo apt-get update -qq - sudo apt-get install -y libc6-dev-i386 libc++-dev python3-dev python-dev postgresql-plpython3-${PGVERSION} - sudo apt-get install postgresql-plpython-${PGVERSION} || true - if [ ${TRAVIS_PYTHON_VERSION} == 2.7 ]; then deactivate; fi; - export PYTHON3_LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/python/${TRAVIS_PYTHON_VERSION}/lib/ - export PYTHON2_LD_LIBRARY_PATH=$LD_LIBRARY_PATH - export LD_LIBRARY_PATH=$(if [ ${TRAVIS_PYTHON_VERSION} == 2.7 ]; then echo $PYTHON2_LD_LIBRARY_PATH; else echo $PYTHON3_LD_LIBRARY_PATH; fi;) - mkdir /tmp/pgdata - /usr/lib/postgresql/${PGVERSION}/bin/initdb -A trust -D /tmp/pgdata - echo "unix_socket_directories='/tmp/'" >> /tmp/pgdata/postgresql.conf - /usr/lib/postgresql/${PGVERSION}/bin/pg_ctl -D /tmp/pgdata start install: - SUDO=$(([ $TRAVIS_PYTHON_VERSION == 2.7 ] && echo "sudo") || echo "" ) - $SUDO pip install setuptools sqlalchemy psycopg2 before_script: - g++ -v - gcc -v python: - 2.7 - 3.8 - 3.7 - 3.5 - 3.4 env: matrix: - PGVERSION=12 - PGVERSION=11 - PGVERSION=10 - PGVERSION=9.6 - PGVERSION=9.5 - PGVERSION=9.4 jobs: exclude: - python: 2.7 env: PGVERSION=12 language: python compiler: - gcc sudo: required dist: xenial script: - which python - PYTHON3_CONFIG=/opt/python/${TRAVIS_PYTHON_VERSION}/bin/python-config - PYTHON2_CONFIG=python2-config - export PYTHON_CONFIG=$(if [ ${TRAVIS_PYTHON_VERSION} == 2.7 ]; then echo $PYTHON2_CONFIG; else echo $PYTHON3_CONFIG; fi;) - export PYTHON3_OVERRIDE=/opt/python/${TRAVIS_PYTHON_VERSION}/bin/python - export PYTHON2_OVERRIDE=/usr/bin/python2 - export PYTHON_OVERRIDE=$(if [ ${TRAVIS_PYTHON_VERSION} == 2.7 ]; then echo $PYTHON2_OVERRIDE; else echo $PYTHON3_OVERRIDE; fi;) - export PYTHON3_LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/python/${TRAVIS_PYTHON_VERSION}/lib/ - export PYTHON2_LD_LIBRARY_PATH=$LD_LIBRARY_PATH - export LD_LIBRARY_PATH=$(if [ ${TRAVIS_PYTHON_VERSION} == 2.7 ]; then echo $PYTHON2_LD_LIBRARY_PATH; else echo $PYTHON3_LD_LIBRARY_PATH; fi;) - export PG_CONFIG=/usr/lib/postgresql/${PGVERSION}/bin/pg_config - export PGHOST=/tmp/ - make && sudo make install - if [ ${TRAVIS_PYTHON_VERSION} != 2.7 ]; then pip install .; fi; - make installcheck after_script: - cat regression.diffs || true - cat regression.out || true