Update PostgreSQL Versions #17
This file contains hidden or 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: Update PostgreSQL Versions | |
| on: | |
| schedule: | |
| # Run weekly on Monday at 9:00 UTC | |
| - cron: "0 9 * * 1" | |
| workflow_dispatch: | |
| # FYI: In addition, manually enable "Allow GitHub Actions to create and approve pull requests" | |
| # in repository settings: Settings > Actions > General > Actions permissions | |
| # (https://github.com/KyleKing/mise-postgres-binary/settings/actions) | |
| permissions: | |
| contents: write | |
| pull-requests: write | |
| jobs: | |
| update-versions: | |
| name: Check for PostgreSQL updates | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v6 | |
| - uses: jdx/mise-action@v4 | |
| with: | |
| experimental: true | |
| - name: Check for version updates | |
| id: check | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| run: ./scripts/sync-postgres-versions.py --check | |
| - name: Apply updates | |
| if: steps.check.outputs.updated == 'true' | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| run: ./scripts/sync-postgres-versions.py --apply | |
| - name: Create Pull Request | |
| if: steps.check.outputs.updated == 'true' | |
| uses: peter-evans/create-pull-request@v8 | |
| with: | |
| token: ${{ secrets.GITHUB_TOKEN }} | |
| commit-message: "chore: update PostgreSQL versions to ${{ steps.check.outputs.new_versions }}" | |
| title: "chore: update PostgreSQL test matrix" | |
| body: | | |
| ## Summary | |
| Automated update of PostgreSQL versions in CI test matrix. | |
| **New versions:** ${{ steps.check.outputs.new_versions }} | |
| This PR was automatically generated by the weekly version check workflow. | |
| ### PostgreSQL Release Policy | |
| PostgreSQL major versions are supported for approximately 5 years. | |
| This plugin tests the oldest, middle, and newest of the 5 actively supported major versions. | |
| ### Verification | |
| - [ ] CI passes with new versions | |
| - [ ] Versions are available from theseus-rs/postgresql-binaries | |
| --- | |
| Generated by [sync-postgres-versions.yml](.github/workflows/sync-postgres-versions.yml) | |
| branch: chore/sync-postgres-versions | |
| delete-branch: true | |
| labels: | | |
| dependencies | |
| automated |