language: c sudo: required env: global: - PGUSER=postgres - PGDATABASE=postgres - PGOPTIONS='-c client_min_messages=NOTICE' jobs: include: - env: POSTGRESQL_VERSION="9.6" POSTGIS_VERSION="2.5" dist: xenial - env: POSTGRESQL_VERSION="10" POSTGIS_VERSION="2.5" dist: xenial - env: POSTGRESQL_VERSION="11" POSTGIS_VERSION="2.5" dist: xenial - env: POSTGRESQL_VERSION="12" POSTGIS_VERSION="2.5" dist: bionic - env: POSTGRESQL_VERSION="12" POSTGIS_VERSION="3" dist: bionic script: - sudo apt-get install -y --allow-unauthenticated --no-install-recommends --no-install-suggests postgresql-$POSTGRESQL_VERSION postgresql-client-$POSTGRESQL_VERSION postgresql-server-dev-$POSTGRESQL_VERSION postgresql-common - if [[ $POSTGRESQL_VERSION == '9.6' ]]; then sudo apt-get install -y postgresql-contrib-9.6; fi; - sudo apt-get install -y --allow-unauthenticated postgresql-$POSTGRESQL_VERSION-postgis-$POSTGIS_VERSION postgresql-$POSTGRESQL_VERSION-postgis-$POSTGIS_VERSION-scripts postgis # For pre12, install plpython2. For PG12 install plpython3 - if [[ $POSTGRESQL_VERSION != '12' ]]; then sudo apt-get install -y postgresql-plpython-$POSTGRESQL_VERSION python python-redis; else sudo apt-get install -y postgresql-plpython3-12 python3 python3-redis; fi; - sudo pg_dropcluster --stop $POSTGRESQL_VERSION main - sudo rm -rf /etc/postgresql/$POSTGRESQL_VERSION /var/lib/postgresql/$POSTGRESQL_VERSION /var/ramfs/postgresql/$POSTGRESQL_VERSION - sudo pg_createcluster -u postgres $POSTGRESQL_VERSION main --start -- --auth-local trust --auth-host password - export PGPORT=$(pg_lsclusters | grep $POSTGRESQL_VERSION | awk '{print $3}') - make - sudo make install - make installcheck after_failure: - pg_lsclusters - cat regression.out - cat regression.diffs - echo $PGPORT - cat /var/log/postgresql/postgresql-$POSTGRESQL_VERSION-main.log