Improve portability of tests with compute_query_id #200
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: regression test | |
| on: | |
| push: | |
| branches: | |
| - PG17 | |
| - PG16 | |
| - PG15 | |
| - PG14 | |
| - PG13 | |
| - PG12 | |
| pull_request: | |
| branches: | |
| - PG17 | |
| - PG16 | |
| - PG15 | |
| - PG14 | |
| - PG13 | |
| - PG12 | |
| schedule: | |
| # Runs at 00:00 UTC on every Sunday. | |
| - cron: "0 0 * * SUN" | |
| jobs: | |
| test: | |
| strategy: | |
| fail-fast: false | |
| runs-on: ubuntu-latest | |
| env: | |
| PGPORT: 55435 | |
| PGUSER: runner | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v2 | |
| - name: Set PATH and PG_VERSION | |
| run: | | |
| if [ "${{ github.ref_name }}" == 'PG17' ]; then | |
| echo "PG_VERSION=17" >> $GITHUB_ENV | |
| elif [ "${{ github.ref_name }}" == 'PG16' ]; then | |
| echo "PG_VERSION=16" >> $GITHUB_ENV | |
| elif [ "${{ github.ref_name }}" == 'PG15' ]; then | |
| echo "PG_VERSION=15" >> $GITHUB_ENV | |
| elif [ "${{ github.ref_name }}" == 'PG14' ]; then | |
| echo "PG_VERSION=14" >> $GITHUB_ENV | |
| elif [ "${{ github.ref_name }}" == 'PG13' ]; then | |
| echo "PG_VERSION=13" >> $GITHUB_ENV | |
| elif [ "${{ github.ref_name }}" == 'PG12' ]; then | |
| echo "PG_VERSION=12" >> $GITHUB_ENV | |
| fi | |
| - name: Build PostgreSQL | |
| run: | | |
| sudo -nH apt-get -q update | |
| sudo -nH apt-get -y install libreadline-dev zlib1g-dev bison flex gcc | |
| wget -q -O postgresql.tar.bz2 https://ftp.postgresql.org/pub/snapshot/${PG_VERSION}/postgresql-${PG_VERSION}-snapshot.tar.bz2 | |
| mkdir -p ~/source | |
| tar --extract --file postgresql.tar.bz2 --directory ~/source --strip-components 1 | |
| cd ~/source | |
| ./configure --prefix=$HOME/pgsql --enable-cassert --enable-debug | |
| make -j 2 | |
| make -C contrib/pg_stat_statements | |
| make -C contrib/file_fdw | |
| make -C contrib/btree_gist | |
| make -C contrib/btree_gin | |
| sudo make install | |
| sudo make -C contrib/pg_stat_statements install | |
| sudo make -C contrib/file_fdw install | |
| sudo make -C contrib/btree_gist install | |
| sudo make -C contrib/btree_gin install | |
| echo "$HOME/pgsql/bin" >> $GITHUB_PATH | |
| - name: Build pg_hint_plan | |
| run: | | |
| make USE_PGXS=1 clean | |
| make USE_PGXS=1 PG_CONFIG=$(which pg_config) | |
| sudo make USE_PGXS=1 PG_CONFIG=$(which pg_config) install | |
| - name: Start PostgreSQL Server | |
| run: | | |
| initdb -D regression_data --no-locale -E UTF8 -A trust | |
| echo "shared_preload_libraries = 'pg_hint_plan,pg_stat_statements,file_fdw'" >> regression_data/postgresql.conf | |
| pg_ctl start -D regression_data -o "-p ${PGPORT}" | |
| - name: Make installcheck | |
| run: | | |
| make installcheck USE_PGXS=1 || status=$? | |
| if test -f regression.diffs; then cat regression.diffs; fi | |
| exit $status | |