WIP policy_is_permissive, policy_is_restrictive #267
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
| name: ✅ Test | |
| on: | |
| push: | |
| branches: ['*'] | |
| pull_request: | |
| schedule: | |
| - cron: '0 14 3 * *' # Monthly at 2pm on the third | |
| jobs: | |
| build: | |
| strategy: | |
| matrix: | |
| include: | |
| - { version: 17, upgrade_to: "", update_from: 0.99.0 } | |
| - { version: 16, upgrade_to: 17, update_from: 0.99.0 } | |
| - { version: 15, upgrade_to: 16, update_from: 0.99.0 } | |
| - { version: 14, upgrade_to: 15, update_from: 0.99.0 } | |
| - { version: 13, upgrade_to: 14, update_from: 0.99.0 } | |
| - { version: 12, upgrade_to: 13, update_from: 0.99.0 } | |
| - { version: 11, upgrade_to: 12, update_from: 0.99.0 } # Versions prior to 0.99.0 don't support Postgres 11 | |
| - { version: 10, upgrade_to: 11, update_from: 0.95.0 } | |
| - { version: 9.6, upgrade_to: 10, update_from: 0.95.0 } | |
| - { version: 9.5, upgrade_to: 9.6, update_from: 0.95.0 } | |
| - { version: 9.4, upgrade_to: 9.5, update_from: 0.95.0 } | |
| - { version: 9.3, upgrade_to: 9.4, update_from: 0.95.0 } | |
| - { version: 9.2, upgrade_to: 9.3, update_from: "" } # updatecheck is not supported prior to 9.3 | |
| - { version: 9.1, upgrade_to: 9.2, update_from: "" } # updatecheck is not supported prior to 9.3 | |
| # Also test pg_upgrade across many versions | |
| - { version: 9.2, upgrade_to: 17, update_from: "", suffix: –17 } | |
| - { version: 9.4, upgrade_to: 17, update_from: "", suffix: –17 } | |
| name: 🐘 PostgreSQL ${{ matrix.version }}${{ matrix.suffix }} | |
| runs-on: ubuntu-latest | |
| container: pgxn/pgxn-tools | |
| env: | |
| PGUSER: postgres | |
| UPDATE_FROM: "${{ matrix.update_from }}" | |
| steps: | |
| - run: pg-start ${{ matrix.version }} | |
| - uses: actions/checkout@v4 | |
| # Basic regression test. | |
| - run: pg-build-test | |
| # Test update. | |
| - run: 'if [ -d "$UPDATE_FROM" ]; then make uninstall clean updatecheck; fi' | |
| # Test all, install, test, test-serial, and test-parallel, both from clean | |
| # repo and repeated with existing build, with and without PARALLEL_CONN=1. | |
| - run: make uninstall clean all | |
| - run: make all | |
| - run: make uninstall clean install | |
| - run: make install | |
| - run: psql -Ec 'CREATE EXTENSION pgtap' | |
| - run: make uninstall clean test | |
| - run: make test | |
| - run: make uninstall clean test PARALLEL_CONN=1 | |
| - run: make test PARALLEL_CONN=1 | |
| - run: make uninstall clean test-serial | |
| - run: make test-serial | |
| - run: make uninstall clean test-serial PARALLEL_CONN=1 | |
| - run: make test-serial PARALLEL_CONN=1 | |
| - run: make uninstall clean test-parallel | |
| - run: make test-parallel | |
| - run: make uninstall clean test-parallel PARALLEL_CONN=1 | |
| - run: make test-parallel PARALLEL_CONN=1 | |
| # Test upgrade last, since the new version's client will be preferred. | |
| - if: ${{ matrix.upgrade_to != '' }} | |
| name: Upgrade to ${{ matrix.upgrade_to }} | |
| # Based on https://gist.github.com/petere/6023944 | |
| # See also https://askubuntu.com/a/104912 for --force options | |
| run: | | |
| make install | |
| sudo apt.postgresql.org.sh -i -v "${{ matrix.upgrade_to }}" | |
| sudo -u postgres test/test_MVU.sh -s 55432 55433 "${{ matrix.version }}" "${{ matrix.upgrade_to }}" |