README: Bump minimum supported PG version #66
Workflow file for this run
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
# GitHub Actions for OGR-FDW | |
# | |
# Paul Ramsey <pramsey at cleverelephant dot ca> | |
name: "CI" | |
on: | |
push: | |
# branches-ignore: | |
# - 'master' | |
pull_request: ~ | |
jobs: | |
linux: | |
name: "CI" | |
strategy: | |
fail-fast: false | |
matrix: | |
ci: | |
- { PGVER: 13 } | |
- { PGVER: 14 } | |
- { PGVER: 15 } | |
- { PGVER: 16 } | |
- { PGVER: 17 } | |
runs-on: ubuntu-latest | |
steps: | |
- name: 'Check Out' | |
uses: actions/checkout@v4 | |
- name: 'Raise Priority for apt.postgresql.org' | |
run: | | |
cat << EOF >> ./pgdg.pref | |
Package: * | |
Pin: release o=apt.postgresql.org | |
Pin-Priority: 600 | |
EOF | |
sudo mv ./pgdg.pref /etc/apt/preferences.d/ | |
sudo apt update | |
- name: 'Install GDAL' | |
run: | | |
sudo apt-get install libgdal-dev | |
- name: 'Install PostgreSQL' | |
run: | | |
sudo apt-get purge postgresql-* | |
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg-snapshot main ${{ matrix.ci.PGVER }}" > /etc/apt/sources.list.d/pgdg.list' | |
curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg >/dev/null | |
sudo apt-get update | |
sudo apt-get -y install postgresql-${{ matrix.ci.PGVER }} postgresql-server-dev-${{ matrix.ci.PGVER }} | |
- name: 'Start PostgreSQL' | |
run: | | |
export PGVER=${{ matrix.ci.PGVER }} | |
export PGDATA=/var/lib/postgresql/$PGVER/main | |
export PGETC=/etc/postgresql/$PGVER/main | |
export PGBIN=/usr/lib/postgresql/$PGVER/bin | |
export RUNNER_USER=`whoami` | |
# make sure postgres user can access data files | |
sudo chmod -R 755 /home/${RUNNER_USER} | |
sudo cp ./ci/pg_hba.conf $PGETC/pg_hba.conf | |
sudo systemctl stop postgresql | |
sudo pg_ctlcluster $PGVER main start | |
sudo pg_lsclusters | |
- name: 'Build & Test' | |
run: | | |
export PATH=/usr/lib/postgresql/${{ matrix.ci.PGVER }}/bin/:$PATH | |
PG_CFLAGS=-Werror make | |
sudo make install | |
PGUSER=postgres make installcheck || (cat regression.diffs && /bin/false) |