Message-ID: <gh-pgjdbc-pgjdbc-4132@github.com>
From: "vlsi (@vlsi)" <noreply+vlsi@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 02 Jun 2026 11:24:53 +0000
Subject: [pgjdbc/pgjdbc] PR #4132: ci: run GSS tests against the runner's default postgresql
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Additions: 2
X-GitHub-Author-Id: 213894
X-GitHub-Author-Login: vlsi
X-GitHub-Base: release/42.4.x
X-GitHub-Changed-Files: 2
X-GitHub-Commits: 1
X-GitHub-Deletions: 2
X-GitHub-Head-Branch: codex/gss-default-postgresql-42.4
X-GitHub-Head-SHA: 9eef71187381a19f48256b3e7fb8b8dd82b0083d
X-GitHub-Issue: 4132
X-GitHub-Labels: building-and-testing
X-GitHub-Merge-SHA: b6b251ad7734c6b36fd8ca38790f73df04f93035
X-GitHub-Merged-By: vlsi
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: merged
X-GitHub-Type: pull_request
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/pull/4132
Content-Type: text/plain; charset=utf-8

## What

Backport of 30ea40dd7013874815eeb9cd103a0c334674e488 (already on `release/42.5.x`) to `release/42.4.x`.

- `main.yml`: install the `postgresql` meta-package instead of `postgresql-12` for the GSS jobs.
- `test-gss/.../TestPostgres.groovy`: point the harness at `/usr/lib/postgresql/16/bin/` instead of `/12/bin/`.

## Why

`ubuntu-24.04` runners no longer ship `postgresql-12`, so the GSS jobs failed first at `apt install` (`Unable to locate package postgresql-12`) and then at `/usr/lib/postgresql/12/bin/initdb: No such file or directory`. The meta-package pulls PostgreSQL 16 on `ubuntu-24.04`, which lives under `/usr/lib/postgresql/16/bin/`. This matches `master` and `release/42.5.x`.

## How to verify

Run the `main` workflow with a `gss == 'yes'` matrix entry and confirm the GSS job installs PostgreSQL and reaches the test phase.

🤖 Generated with [Claude Code](https://claude.com/claude-code)

diff --git a/.github/workflows/main.yml b/.github/workflows/main.yml
index cba891d289..9ed131bdaf 100644
--- a/.github/workflows/main.yml
+++ b/.github/workflows/main.yml
@@ -201,7 +201,7 @@ jobs:
       if: ${{ matrix.gss == 'yes' }}
       run: |
         sudo apt -y update
-        sudo apt -y install krb5-kdc krb5-admin-server libkrb5-dev postgresql-12
+        sudo apt -y install krb5-kdc krb5-admin-server libkrb5-dev postgresql
     - name: 'Update hosts for GSS tests'
       if: ${{ matrix.gss == 'yes' }}
       run: |
diff --git a/test-gss/src/main/groovy/TestPostgres.groovy b/test-gss/src/main/groovy/TestPostgres.groovy
index e3d01740c3..c721d469e8 100644
--- a/test-gss/src/main/groovy/TestPostgres.groovy
+++ b/test-gss/src/main/groovy/TestPostgres.groovy
@@ -47,7 +47,7 @@ class TestPostgres {
         if (isMac)
             postgres = new Postgres()
         else
-            postgres = new Postgres('/usr/lib/postgresql/12/bin/', '/tmp/pggss')
+            postgres = new Postgres('/usr/lib/postgresql/16/bin/', '/tmp/pggss')
         /*
         make sure we can connect
          */