[actions] Fix postgres version regex #1002
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Build for Ubuntu | |
| # manually triggered workflow | |
| # - 5 * 2 * 2 = 20 jobs are triggered | |
| # - So many jobs take too much time | |
| # When this file changes | |
| on: | |
| workflow_dispatch: | |
| push: | |
| paths: | |
| - '.github/workflows/ubuntu.yml' | |
| branches-ignore: | |
| - 'gh-pages' | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.ref }} | |
| cancel-in-progress: true | |
| permissions: | |
| contents: read | |
| jobs: | |
| build: | |
| name: Ubuntu psql | |
| runs-on: ${{ matrix.os }} | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| psql: [11,12,13,14,15] | |
| postgis: [3] | |
| os: [ubuntu-latest, ubuntu-20.04] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: get postgres version | |
| run: | | |
| sudo service postgresql start | |
| pgver=$(psql --version | grep -Po '(?<=psql \(PostgreSQL\) )[^;]+(?=\.\d+ \()') | |
| echo "PGVER=${pgver}" >> $GITHUB_ENV | |
| PGP=5433 | |
| if [ "${{ matrix.psql }}" == "${pgver}" ]; then PGP=5432; fi | |
| echo "PGPORT=${PGP}" >> $GITHUB_ENV | |
| - name: Add PostgreSQL APT repository | |
| run: | | |
| sudo apt-get install curl ca-certificates gnupg | |
| curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - | |
| sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ \ | |
| $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' | |
| - name: Install dependencies | |
| run: | | |
| sudo apt-get update | |
| sudo apt-get install -y \ | |
| libboost-graph-dev \ | |
| libtap-parser-sourcehandler-pgtap-perl \ | |
| postgresql-${{ matrix.psql }} \ | |
| postgresql-${{ matrix.psql }}-pgtap \ | |
| postgresql-${{ matrix.psql }}-postgis-${{ matrix.postgis }} \ | |
| postgresql-${{ matrix.psql }}-postgis-${{ matrix.postgis }}-scripts \ | |
| postgresql-server-dev-${{ matrix.psql }} | |
| - name: Configure for gcc | |
| run: | | |
| export PATH=/usr/lib/postgresql/${{ matrix.psql }}/bin:$PATH | |
| mkdir build | |
| cd build | |
| cmake -DPOSTGRESQL_VERSION=${{ matrix.psql }} -DCMAKE_BUILD_TYPE=Release -DWITH_DOC=OFF .. | |
| - name: Build | |
| run: | | |
| cd build | |
| make -j 4 | |
| sudo make install | |
| - name: Test | |
| run: | | |
| sudo service postgresql start | |
| export PG_RUNNER_USER=`whoami` | |
| sudo -u postgres psql -p ${PGPORT} -c "DROP DATABASE IF EXISTS ___pgr___test___;" | |
| sudo -u postgres psql -p ${PGPORT} -c "DROP DATABASE IF EXISTS \"${PG_RUNNER_USER}\";" | |
| sudo -u postgres psql -p ${PGPORT} -c "DROP ROLE IF EXISTS \"${PG_RUNNER_USER}\";" | |
| sudo -u postgres psql -p ${PGPORT} -c "CREATE ROLE \"${PG_RUNNER_USER}\" WITH LOGIN SUPERUSER;" | |
| sudo -u postgres psql -p ${PGPORT} -c "CREATE DATABASE \"${PG_RUNNER_USER}\";" | |
| psql -c "CREATE DATABASE ___pgr___test___;" | |
| bash ./tools/testers/pg_prove_tests.sh ${PG_RUNNER_USER} ${PGPORT} Release | |
| psql -c "DROP DATABASE IF EXISTS ___pgr___test___;" |