build.yml

name: Container Images from PostgreSQL sources

on:
  workflow_dispatch:
    inputs:
      pg_repo:
        description: "Name of the target PG repository"
        required: true
        default: "https://git.postgresql.org/git/postgresql.git"
      pg_branch:
        description: "Name of the branch in the target PG repository"
        required: true
        default: "master"
      major_version:
        description: "PostgreSQL major version (leave empty for default)"
        required: false

defaults:
  run:
    # default failure handling for shell scripts in 'run' steps
    shell: 'bash -Eeuo pipefail -x {0}'

permissions: read-all

jobs:
  build-pg:
    name: Build generic PostgreSQL image from sources
    runs-on: ${{ github.repository_owner == 'cloudnative-pg' && 'ubuntu-latest-16-cores' || 'ubuntu-24.04' }}
    permissions:
      contents: read
      packages: write
    outputs:
      images: ${{ env.IMAGES }}
      pg_major: ${{ env.PG_MAJOR }}
    steps:
    - name: Checkout Code
      uses: actions/checkout@v6

    - name: Set env variables from defaults.json
      run: |
        for key in $(jq -r 'keys[]' defaults.json); do
          echo "$key=$(cat defaults.json | jq -r --arg key "$key" '.[$key]')" >> $GITHUB_ENV
        done

    # Inputs have priority over defaults.json.
    - name: Evaluate E2E workflow inputs
      env:
        INPUT_MAJOR_VERSION: ${{ github.event.inputs.major_version }}
      run: |
        if [[ -n "${INPUT_MAJOR_VERSION}" ]]; then
          echo "PG_MAJOR=${INPUT_MAJOR_VERSION}" >> $GITHUB_ENV
        fi

    - name: Log in to the GitHub Container registry
      uses: docker/login-action@v4
      with:
        registry: ghcr.io
        username: ${{ github.actor }}
        password: ${{ secrets.GITHUB_TOKEN }}

    - name: Set up Docker Buildx
      uses: docker/setup-buildx-action@v4

    - name: Build and push
      uses: docker/bake-action@v7
      id: build
      env:
        environment: production
        registry: ghcr.io/${{ github.repository_owner }}
        revision: ${{ github.sha }}
        pgMajor: ${{ env.PG_MAJOR }}
      with:
        set: |
          *.args.PG_REPO=${{ github.event.inputs.pg_repo }}
          *.args.PG_BRANCH=${{ github.event.inputs.pg_branch }}
          minimal.tags=${{ env.registry }}/postgresql-trunk:${{ env.PG_MAJOR }}-minimal-${{ github.run_number }}
          standard.tags=${{ env.registry }}/postgresql-trunk:${{ env.PG_MAJOR }}-standard-${{ github.run_number }}
          postgis.tags=${{ env.registry }}/postgresql-trunk:${{ env.PG_MAJOR }}-postgis-${{ github.run_number }}
        push: true

    # Get a list of the images that were built and pushed.
    - name: Generated images
      id: images
      env:
        BUILD_METADATA: ${{ steps.build.outputs.metadata }}
      run: |
        IMAGES="$(echo "${BUILD_METADATA}" | jq -r '.[]."image.name"')"
        {
          echo 'IMAGES<<EOF'
          echo "${IMAGES}"
          echo EOF
        } >> $GITHUB_ENV

  generate-summary:
    name: PostgreSQL Image Build summary
    runs-on: ubuntu-24.04
    needs:
      - build-pg
    steps:
      - name: Output summary
        env:
          BUILD_PG_MAJOR: ${{ needs.build-pg.outputs.pg_major }}
          BUILD_PG_IMAGES: ${{ needs.build-pg.outputs.images }}
        run: |
          pg_major="${BUILD_PG_MAJOR}"
          images="${BUILD_PG_IMAGES}"
          images_list="$(echo $images | tr ' ' '\n' | sed 's/^/https:\/\//')"
          minimalImage="$(echo $images | tr ' ' '\n' | grep minimal)"

          echo "# PostgreSQL Image Build summary" >> $GITHUB_STEP_SUMMARY
          echo "Here's the list of Container Images that have been built:" >> $GITHUB_STEP_SUMMARY
          echo "$images_list" >> $GITHUB_STEP_SUMMARY

          echo "## CloudNativePG Cluster definition (example using the minimal image)" >> $GITHUB_STEP_SUMMARY
          echo "You can create a cluster in CloudNativePG running this image:" >> $GITHUB_STEP_SUMMARY
          echo "\`\`\`sh" >> $GITHUB_STEP_SUMMARY
          echo "(cat <<EOF" >> $GITHUB_STEP_SUMMARY
          echo "apiVersion: postgresql.cnpg.io/v1" >> $GITHUB_STEP_SUMMARY
          echo "kind: Cluster" >> $GITHUB_STEP_SUMMARY
          echo "metadata:" >> $GITHUB_STEP_SUMMARY
          echo "  name: pg-$pg_major-build" >> $GITHUB_STEP_SUMMARY
          echo "spec:" >> $GITHUB_STEP_SUMMARY
          echo "  imageName: $minimalImage" >> $GITHUB_STEP_SUMMARY
          echo "  instances: 3" >> $GITHUB_STEP_SUMMARY
          echo "  storage:" >> $GITHUB_STEP_SUMMARY
          echo "    size: 1Gi" >> $GITHUB_STEP_SUMMARY
          echo "EOF" >> $GITHUB_STEP_SUMMARY
          echo ") | kubectl apply -f -" >> $GITHUB_STEP_SUMMARY
          echo "\`\`\`" >> $GITHUB_STEP_SUMMARY