Upgrade to PG17 (#485) #350
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-latest | |
| on: | |
| workflow_dispatch: | |
| pull_request: | |
| branches: | |
| - develop | |
| paths: | |
| - 'Dockerfile' | |
| - 'scripts/**' | |
| - 'base_build/**' | |
| - '.github/workflows/**' | |
| push: | |
| branches: | |
| - develop | |
| paths: | |
| - 'Dockerfile' | |
| - 'scripts/**' | |
| - 'build_data/**' | |
| - '.github/workflows/**' | |
| jobs: | |
| build-docker-image: | |
| runs-on: ubuntu-latest | |
| timeout-minutes: 25 | |
| if: | | |
| github.actor != 'dependabot[bot]' && | |
| !( | |
| contains(github.event.pull_request.title, '[skip-release]') || | |
| contains(github.event.comment.body, '/skiprelease') | |
| ) | |
| strategy: | |
| matrix: | |
| postgresMajorVersion: | |
| - 17 | |
| postgisMajorVersion: | |
| - 3 | |
| postgisMinorRelease: | |
| - 5 | |
| imageVersion: | |
| - imageDistro: debian | |
| imageDistroVersion: bookworm | |
| imageDistroVariant: slim | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up QEMU | |
| uses: docker/setup-qemu-action@v3 | |
| - name: Set up Docker Buildx | |
| uses: docker/setup-buildx-action@v3 | |
| - name: Build image for testing | |
| id: docker_build_testing_image | |
| uses: docker/build-push-action@v6 | |
| with: | |
| context: . | |
| file: Dockerfile | |
| push: false | |
| load: true | |
| tags: kartoza/postgis:manual-build | |
| outputs: type=docker,dest=/tmp/postgis.tar | |
| build-args: | | |
| DISTRO=${{ matrix.imageVersion.imageDistro }} | |
| IMAGE_VERSION=${{ matrix.imageVersion.imageDistroVersion }} | |
| IMAGE_VARIANT=${{ matrix.imageVersion.imageDistroVariant }} | |
| LANGS=en_US.UTF-8,id_ID.UTF-8 | |
| GENERATE_ALL_LOCALE=0 | |
| POSTGRES_MAJOR_VERSION=${{ matrix.postgresMajorVersion }} | |
| POSTGIS_MAJOR_VERSION=${{ matrix.postgisMajorVersion }} | |
| POSTGIS_MINOR_VERSION=${{ matrix.postgisMinorRelease }} | |
| cache-from: | | |
| type=gha,scope=test | |
| type=gha,scope=prod | |
| type=gha,scope=base | |
| cache-to: type=gha,scope=test | |
| target: postgis-test | |
| - name: Upload artifact | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: kartoza-postgis | |
| path: /tmp/postgis.tar | |
| run-scenario-tests: | |
| runs-on: ubuntu-latest | |
| needs: [build-docker-image] | |
| timeout-minutes: 20 | |
| if: | | |
| github.actor != 'dependabot[bot]' && | |
| !( | |
| contains(github.event.pull_request.title, '[skip-release]') || | |
| contains(github.event.comment.body, '/skiprelease') | |
| ) | |
| strategy: | |
| matrix: | |
| scenario: | |
| - datadir_init | |
| - streaming_replication | |
| - collations | |
| - extensions | |
| - logical_replication | |
| - init_scripts | |
| - multiple_databases | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Download artifact | |
| uses: actions/download-artifact@v4 | |
| with: | |
| name: kartoza-postgis | |
| path: /tmp | |
| - name: Load image | |
| run: | | |
| docker load --input /tmp/postgis.tar | |
| - name: Run scenario test ${{ matrix.scenario }} | |
| working-directory: scenario_tests/${{ matrix.scenario }} | |
| env: | |
| COMPOSE_INTERACTIVE_NO_CLI: 1 | |
| PRINT_TEST_LOGS: 1 | |
| run: | | |
| bash ./test.sh | |
| scan_image: | |
| runs-on: ubuntu-latest | |
| timeout-minutes: 20 | |
| if: | | |
| github.actor != 'dependabot[bot]' && | |
| !( | |
| contains(github.event.pull_request.title, '[skip-release]') || | |
| contains(github.event.comment.body, '/skiprelease') | |
| ) | |
| needs: [build-docker-image, run-scenario-tests] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Download artifact | |
| uses: actions/download-artifact@v4 | |
| with: | |
| name: kartoza-postgis | |
| path: /tmp | |
| - name: Load image | |
| run: | | |
| docker load --input /tmp/postgis.tar | |
| - name: Run Trivy vulnerability scanner | |
| uses: aquasecurity/trivy-action@master | |
| with: | |
| format: 'sarif' | |
| ignore-unfixed: true | |
| image-ref: kartoza/postgis:manual-build | |
| output: 'trivy-results.sarif' | |
| severity: 'CRITICAL,HIGH' | |
| vuln-type: 'os,library' | |
| - name: Upload Trivy scan results to GitHub Security tab | |
| uses: github/codeql-action/upload-sarif@v3 | |
| with: | |
| sarif_file: 'trivy-results.sarif' | |
| push-internal-pr-images: | |
| if: | | |
| github.event_name == 'pull_request' && | |
| github.event.pull_request.base.repo.url == github.event.pull_request.head.repo.url && | |
| github.actor != 'dependabot[bot]' && | |
| !( | |
| contains(github.event.pull_request.title, '[skip-release]') || | |
| contains(github.event.comment.body, '/skiprelease') | |
| ) | |
| runs-on: ubuntu-latest | |
| needs: [ build-docker-image, run-scenario-tests ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Download artifact | |
| uses: actions/download-artifact@v4 | |
| with: | |
| name: kartoza-postgis | |
| path: /tmp | |
| - name: Load image | |
| run: | | |
| docker load --input /tmp/postgis.tar | |
| - name: Login to DockerHub | |
| uses: docker/login-action@v3 | |
| with: | |
| username: ${{ secrets.DOCKERHUB_USERNAME }} | |
| password: ${{ secrets.DOCKERHUB_PASSWORD }} | |
| - name: Docker meta | |
| id: docker_meta | |
| uses: docker/metadata-action@v5 | |
| with: | |
| images: ${{ secrets.DOCKERHUB_REPO}}/postgis | |
| tags: | | |
| type=semver,pattern=\d.\d.\d | |
| type=ref,event=branch | |