pg_upgrade-test.yaml

name: pg_upgrade test
"on":
  push:
    branches:
      - main
      - ?.*.x
      - prerelease_test
  pull_request:

jobs:
  check_paths:
    runs-on: ubuntu-latest
    outputs:
      run_ci: >-
        ${{ github.event_name == 'push'
          || (steps.filter.outputs.sql == 'true' && !contains(github.event.pull_request.labels.*.name, 'skip-ci'))
         }}
    steps:
      - uses: actions/checkout@3d3c42e5aac5ba805825da76410c181273ba90b1 # v7.0.1
      - uses: dorny/paths-filter@7b450fff21473bca461d4b92ce414b9d0420d706 # v4.0.2
        id: filter
        with:
          filters: .github/filters.yaml

  pg_upgrade_test:
    needs: check_paths
    if: needs.check_paths.outputs.run_ci == 'true'
    name: pg_upgrade test from PG${{ matrix.pg_version_old }} to PG${{ matrix.pg_version_new }}
    runs-on: 'ubuntu-latest'
    strategy:
      matrix:
        include:
          - pg_version_old: 16 # 16 to 17
            pg_version_new: 17
          - pg_version_old: 16 # 16 to 18
            pg_version_new: 18
          - pg_version_old: 17 # 17 to 18
            pg_version_new: 18
      fail-fast: false
    env:
      OUTPUT_DIR: ${{ github.workspace }}/pg_upgrade_test

    steps:
      - name: Install Linux Dependencies
        timeout-minutes: 15
        run: |
          sudo apt-get update
          sudo apt-get install pip postgresql-common

      - name: Install testgres
        run: |
          pip install testgres

      - name: Install PostgreSQL ${{ matrix.pg_version_old}} and ${{ matrix.pg_version_new }}
        timeout-minutes: 15
        run: |
          yes | sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
          echo "deb https://packagecloud.io/timescale/timescaledb/ubuntu/ $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/timescaledb.list
          wget --quiet --tries=6 --waitretry=15 -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add -
          sudo apt-get update
          sudo apt-get install -y \
            postgresql-${{ matrix.pg_version_old }} postgresql-server-dev-${{ matrix.pg_version_old }} \
            postgresql-${{ matrix.pg_version_new }} postgresql-server-dev-${{ matrix.pg_version_new }}
          sudo apt-get install -y --no-install-recommends \
            timescaledb-2-postgresql-${{ matrix.pg_version_old }} \
            timescaledb-2-postgresql-${{ matrix.pg_version_new }}

      - name: Checkout TimescaleDB
        uses: actions/checkout@3d3c42e5aac5ba805825da76410c181273ba90b1 # v7.0.1

      - name: Build and install TimescaleDB on PostgreSQL ${{ matrix.pg_version_old}}
        env:
          BUILD_DIR: pg${{ matrix.pg_version_old }}
        run: |
          PATH="/usr/lib/postgresql/${{ matrix.pg_version_old }}/bin:$PATH"
          ./bootstrap -DCMAKE_BUILD_TYPE=Release -DWARNINGS_AS_ERRORS=OFF -DASSERTIONS=ON -DLINTER=OFF -DGENERATE_DOWNGRADE_SCRIPT=OFF -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF
          make -j -C pg${{ matrix.pg_version_old }}
          sudo make -j -C pg${{ matrix.pg_version_old }} install

      - name: Build and install TimescaleDB on PostgreSQL ${{ matrix.pg_version_new}}
        env:
          BUILD_DIR: pg${{ matrix.pg_version_new }}
        run: |
          PATH="/usr/lib/postgresql/${{ matrix.pg_version_new }}/bin:$PATH"
          ./bootstrap -DCMAKE_BUILD_TYPE=Release -DWARNINGS_AS_ERRORS=OFF -DASSERTIONS=ON -DLINTER=OFF -DGENERATE_DOWNGRADE_SCRIPT=OFF -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF
          make -j -C pg${{ matrix.pg_version_new }}
          sudo make -j -C pg${{ matrix.pg_version_new }} install

      - name: Run pg_upgrade test
        env:
          PGVERSIONOLD: ${{ matrix.pg_version_old }}
          PGVERSIONNEW: ${{ matrix.pg_version_new }}
          DIFFFILE: ${{ env.OUTPUT_DIR }}/upgrade_check.diff
        run: |
          scripts/test_pg_upgrade.py
          diff -u \
            "${OUTPUT_DIR}/post.pg${PGVERSIONOLD}.log" \
            "${OUTPUT_DIR}/post.pg${PGVERSIONNEW}.log" | \
            tee "${DIFFFILE}"
          if [[ -s "${DIFFFILE}" ]]; then
            echo "pg_upgrade test for ${PGVERSIONOLD} -> ${PGVERSIONNEW} failed"
            exit 1
          fi

      - name: Show pg_upgrade diffs
        if: always()
        env:
          DIFFFILE: ${{ env.OUTPUT_DIR }}/upgrade_check.diff
          DIROLD: pg${{ matrix.pg_version_old }}
          DIRNEW: pg${{ matrix.pg_version_new }}
        run: |
          cd ${OUTPUT_DIR}
          cat ${DIFFFILE}
          tar czf /tmp/pg_upgrade_artifacts.tgz \
            ${DIFFFILE} \
            ${OUTPUT_DIR}/*.log \
            ${OUTPUT_DIR}/${DIROLD}/logs/* \
            ${OUTPUT_DIR}/${DIRNEW}/logs/* \
            ${OUTPUT_DIR}/${DIRNEW}/data/pg_upgrade_output.d/*

      - name: Upload pg_upgrade logs
        if: always()
        uses: actions/upload-artifact@043fb46d1a93c77aae656e7c1c64a875d1fc6a0a # v7.0.1
        with:
          name: pg_upgrade logs from ${{ matrix.pg_version_old }} to ${{ matrix.pg_version_new }}
          path: /tmp/pg_upgrade_artifacts.tgz

  report_status:
    name: pg_upgrade summary
    needs: [check_paths, pg_upgrade_test]
    if: always()
    runs-on: timescaledb-runner-arm64
    steps:
      - run: |
          # If the detector failed, or the matrix failed, exit with error
          if [[ "${{ needs.pg_upgrade_test.result }}" == "failure" ]]; then
            exit 1
          fi
          echo "All checks passed or were safely skipped."