Skip to content

latest-postgres-version-check #313

latest-postgres-version-check

latest-postgres-version-check #313

# Checks the latest postgres image from `ghcr.io/cloudnative-pg/postgresql`,
# and if there is a new one, updates the codebase with it
name: latest-postgres-version-check
on:
schedule:
- cron: "30 0 * * *"
workflow_dispatch:
defaults:
run:
shell: "bash -Eeuo pipefail -x {0}"
jobs:
check-latest-postgres-version:
runs-on: ubuntu-22.04
steps:
- name: Checkout code
uses: actions/checkout@v4
- name: Set up Python 3.9
uses: actions/setup-python@v5
with:
python-version: 3.9
- name: Install Python dependencies
run: |
pip install packaging
- name: Generate PostgreSQL JSON files
run: |
python .github/postgres-versions-update.py
- name: Get the latest version of PostgreSQL Docker image
id: latest
env:
IMAGE_REPO: ghcr.io/cloudnative-pg/postgresql
run: |
LATEST_POSTGRES_VERSION=$(jq -r 'del(.[] | select(.[] | match("alpha|beta|rc"))) | .[keys | max][0]' < .github/pg_versions.json)
LATEST_POSTGRES_VERSION_IMAGE="${IMAGE_REPO}:${LATEST_POSTGRES_VERSION}"
echo "LATEST_POSTGRES_VERSION=$LATEST_POSTGRES_VERSION" >> $GITHUB_ENV
echo "LATEST_POSTGRES_VERSION_IMAGE=$LATEST_POSTGRES_VERSION_IMAGE" >> $GITHUB_ENV
- name: Get the current version of PostgreSQL
id: current
run: |
CURRENT_POSTGRES_VERSION_IMAGE=$(awk -F '"' '/DefaultImageName *=/{print $2}' pkg/versions/versions.go)
CURRENT_POSTGRES_VERSION=${CURRENT_POSTGRES_VERSION_IMAGE##*:}
echo "CURRENT_POSTGRES_VERSION=$CURRENT_POSTGRES_VERSION" >> $GITHUB_ENV
echo "CURRENT_POSTGRES_VERSION_IMAGE=$CURRENT_POSTGRES_VERSION_IMAGE" >> $GITHUB_ENV
- name: Update files to match the latest version of PostgreSQL
if: env.LATEST_POSTGRES_VERSION_IMAGE != env.CURRENT_POSTGRES_VERSION_IMAGE
env:
CURRENT_POSTGRES_VERSION: ${{ env.CURRENT_POSTGRES_VERSION }}
LATEST_POSTGRES_VERSION: ${{ env.LATEST_POSTGRES_VERSION }}
LATEST_POSTGRES_VERSION_IMAGE: ${{ env.LATEST_POSTGRES_VERSION_IMAGE }}
run: |
echo "New PostgreSQL version detected ; updating!"
# Update pkg/versions/versions.go
sed -i '/DefaultImageName *=/s@".*"@"'"${LATEST_POSTGRES_VERSION_IMAGE}"'"@' pkg/versions/versions.go
# Update docs directory (only .md and .yaml filename extensions)
find docs -type f \( -name '*.md' -o -name '*.yaml' \) \! -path '*release_notes*' -exec sed -i "/[ :]${CURRENT_POSTGRES_VERSION//./\\.}/s/${CURRENT_POSTGRES_VERSION//./\\.}/${LATEST_POSTGRES_VERSION}/g" {} +
- name: Create PR to update PostgreSQL version
if: env.LATEST_POSTGRES_VERSION_IMAGE != env.CURRENT_POSTGRES_VERSION_IMAGE
uses: peter-evans/create-pull-request@v6
env:
GITHUB_TOKEN: ${{ secrets.REPO_GHA_PAT }}
with:
title: "feat: update default PostgreSQL version to ${{ env.LATEST_POSTGRES_VERSION }}"
body: "Update default PostgreSQL version from ${{ env.CURRENT_POSTGRES_VERSION }} to ${{ env.LATEST_POSTGRES_VERSION }}"
branch: "postgres-versions-update"
author: "postgres-versions-updater <[email protected]>"
commit-message: "feat: update default PostgreSQL version to ${{ env.LATEST_POSTGRES_VERSION }}"
signoff: true
- name: Create Pull Request if postgresql versions have been updated
if: env.LATEST_POSTGRES_VERSION_IMAGE == env.CURRENT_POSTGRES_VERSION_IMAGE
uses: peter-evans/create-pull-request@v6
env:
GITHUB_TOKEN: ${{ secrets.REPO_GHA_PAT }}
with:
title: "test: Updated Postgres versions used in E2E tests"
body: "Update the Postgres versions used in E2E tests"
branch: "postgres-versions-update"
author: "postgres-versions-updater <[email protected]>"
add-paths: ".github/"
commit-message: "test: Updated Postgres versions used in E2E tests"
signoff: true