Allow pg_partman to be installed in any schema (#310) #1049
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: PGMQ Extension | |
| defaults: | |
| run: | |
| shell: bash | |
| working-directory: ./pgmq-extension | |
| on: | |
| pull_request: | |
| branches: | |
| - main | |
| paths: | |
| - "pgmq-extension/**" | |
| - ".github/workflows/extension_ci.yml" | |
| push: | |
| branches: | |
| - main | |
| paths: | |
| - "pgmq-extension/**" | |
| - ".github/workflows/extension_ci.yml" | |
| release: | |
| types: | |
| - created | |
| jobs: | |
| test: | |
| name: Test 🐘 ${{ matrix.pg }} with pg_partman ${{ matrix.partman }} | |
| runs-on: ubuntu-22.04 | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| pg: [12, 13, 14, 15, 16, 17] | |
| partman: [4.7.3, 5.1.0] | |
| exclude: | |
| # pg_partman does not support pg < 14 | |
| - pg: 12 | |
| partman: 5.1.0 | |
| - pg: 13 | |
| partman: 5.1.0 | |
| container: pgxn/pgxn-tools | |
| steps: | |
| - run: pg-start ${{ matrix.pg }} | |
| working-directory: ./ | |
| - uses: actions/checkout@v4 | |
| - run: pgxn install 'pg_partman=${{ matrix.partman }}' | |
| - run: pg-build-test | |
| publish: | |
| name: trunk publish | |
| runs-on: ubuntu-22.04 | |
| strategy: | |
| matrix: | |
| pg-version: [14, 15, 16] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Install Rust stable toolchain | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| toolchain: stable | |
| - uses: Swatinem/rust-cache@v2 | |
| with: | |
| prefix-key: "pgmq-extension-test" | |
| workspaces: | | |
| pgmq/pgmq-extension | |
| - name: Install stoml and pg-trunk | |
| shell: bash | |
| run: | | |
| set -xe | |
| wget https://github.com/freshautomations/stoml/releases/download/v0.7.1/stoml_linux_amd64 &> /dev/null | |
| mv stoml_linux_amd64 stoml | |
| chmod +x stoml | |
| sudo mv stoml /usr/local/bin/ | |
| cargo install pg-trunk | |
| - name: Make trunk | |
| run: make Trunk.toml | |
| - name: trunk build | |
| run: trunk build --pg-version ${{ matrix.pg-version }} | |
| - name: trunk publish | |
| # only publish release events | |
| if: github.event_name == 'release' | |
| env: | |
| TRUNK_API_TOKEN: ${{ secrets.TRUNK_AUTH_TOKEN }} | |
| run: | | |
| pgmq_ver=$(stoml Trunk.toml extension.version) | |
| pgmq_descr=$(stoml Trunk.toml extension.description) | |
| pgmq_repo=$(stoml Trunk.toml extension.repository) | |
| trunk publish pgmq --version ${pgmq_ver} --description "A lightweight message queue. Like AWS SQS and RSMQ, on Postgres." --homepage "https://github.com/tembo-io/pgmq" --repository "https://github.com/tembo-io/pgmq" --license "PostgreSQL" --category featured --category orchestration | |
| build_and_push: | |
| name: Build and push images | |
| runs-on: | |
| - self-hosted | |
| - dind | |
| - large-8x8 | |
| strategy: | |
| matrix: | |
| pg: [14, 15, 16] | |
| outputs: | |
| short_sha: ${{ steps.versions.outputs.SHORT_SHA }} | |
| steps: | |
| - name: Check out the repo | |
| uses: actions/checkout@v4 | |
| - name: Install stoml | |
| shell: bash | |
| run: | | |
| set -xe | |
| wget https://github.com/freshautomations/stoml/releases/download/v0.7.1/stoml_linux_amd64 &> /dev/null | |
| mv stoml_linux_amd64 stoml | |
| chmod +x stoml | |
| sudo mv stoml /usr/local/bin/ | |
| - name: Set version strings | |
| id: versions | |
| run: | | |
| echo "SHORT_SHA=$(git rev-parse --short HEAD)" >> $GITHUB_OUTPUT | |
| echo "TAG_VER=$(grep 'default_version' pgmq.control | cut -d "'" -f 2)" >> $GITHUB_OUTPUT | |
| - name: Set up QEMU | |
| uses: docker/setup-qemu-action@v3 | |
| - name: Set up Docker Buildx | |
| uses: docker/setup-buildx-action@v3 | |
| - name: Login to Quay | |
| uses: docker/login-action@v2 | |
| with: | |
| registry: quay.io/tembo | |
| username: ${{ secrets.QUAY_USER_TEMBO }} | |
| password: ${{ secrets.QUAY_PASSWORD_TEMBO }} | |
| - name: Generate dockerfile from template file | |
| working-directory: ./ | |
| run: ./images/pgmq-pg/replace-pg-version.sh ${{ matrix.pg }} ./images/pgmq-pg/Dockerfile.in ./images/pgmq-pg/Dockerfile | |
| - name: Build and push -- Commit | |
| # push commit build when not a release | |
| if: github.event_name != 'release' | |
| uses: docker/build-push-action@v5 | |
| with: | |
| working-directory: ./ | |
| file: ./images/pgmq-pg/Dockerfile | |
| context: . | |
| platforms: linux/amd64, linux/arm64 | |
| push: true | |
| tags: | | |
| quay.io/tembo/pg${{matrix.pg}}-pgmq:v${{ steps.versions.outputs.SHORT_SHA }} | |
| - name: Build and push -- Releases | |
| # only publish release events | |
| if: github.event_name == 'release' | |
| uses: docker/build-push-action@v5 | |
| with: | |
| working-directory: ./ | |
| file: ./images/pgmq-pg/Dockerfile | |
| context: . | |
| platforms: linux/amd64, linux/arm64 | |
| push: true | |
| tags: | | |
| quay.io/tembo/pg${{matrix.pg}}-pgmq:v${{ steps.versions.outputs.TAG_VER }} | |
| quay.io/tembo/pg${{matrix.pg}}-pgmq:latest |