ci: gate postgres-backend tests against a pgvector service container

jphein · claude · jphein · commit da0bdbbb0941 · 2026-05-11T07:45:58.000-07:00
Adds a new test-postgres job to .github/workflows/ci.yml. Runs in
parallel with the existing test-linux / test-windows / test-macos /
lint matrix; doesn't disturb their behavior.

Service container: pgvector/pgvector:pg16 (public Docker Hub image,
PG16 + pgvector pre-installed). Bound on localhost:5432 in the job
network. Pre-test setup step creates the vector extension inside
the mempalace_test database (idempotent IF NOT EXISTS).

Test scope: tests/test_backends_postgres.py only. The full pytest
suite is already exercised by test-linux without the postgres extra;
running it again with TEST_POSTGRES_DSN set would double the suite
time on every PR for the marginal coverage of three additional tests.
The targeted job gives us the regression signal we want — postgres
backend works end-to-end against a real database — without the cost.

AGE is deliberately not in the CI image. The apache/age + pgvector
combined image we deploy on the homelab (mempalace-db on disks) isn't
needed in CI yet — no test in the repo exercises AGE-specific
behavior. When the knowledge-graph layer lands and adds AGE tests,
the CI image swap is a separate concern (push our mempalace-db:0.1
image to ghcr.io/jphein, or build inline in CI). Until then,
pgvector-only is the cheapest correct substrate.

The CREATE EXTENSION step uses a Python heredoc with the DSN passed
via env var (PGURL) rather than inline psql — avoids the
postgresql-client install on the runner and removes one shell-quoting
surface.

Co-Authored-By: Claude Opus 4.7 (1M context) &lt;noreply@anthropic.com&gt;
diff --git a/.github/workflows/ci.yml b/.github/workflows/ci.yml
@@ -53,3 +53,41 @@ jobs:
       - run: pip install "ruff>=0.4.0,<0.5"
       - run: ruff check .
       - run: ruff format --check .
+
+  test-postgres:
+    runs-on: ubuntu-latest
+    services:
+      postgres:
+        image: pgvector/pgvector:pg16
+        env:
+          POSTGRES_PASSWORD: postgres
+          POSTGRES_DB: mempalace_test
+        ports:
+          - 5432:5432
+        options: >-
+          --health-cmd pg_isready
+          --health-interval 5s
+          --health-timeout 5s
+          --health-retries 10
+    steps:
+      - uses: actions/checkout@v6
+      - uses: actions/setup-python@v6
+        with:
+          python-version: "3.11"
+          cache: 'pip'
+      - run: pip install -e ".[dev,postgres]"
+      - name: Create pgvector extension
+        env:
+          PGURL: postgresql://postgres:postgres@localhost:5432/mempalace_test
+        run: |
+          python - <<'PY'
+          import os, psycopg2
+          conn = psycopg2.connect(os.environ["PGURL"])
+          conn.autocommit = True
+          conn.cursor().execute("CREATE EXTENSION IF NOT EXISTS vector")
+          print("vector extension ready")
+          PY
+      - name: Run postgres backend tests
+        env:
+          TEST_POSTGRES_DSN: postgresql://postgres:postgres@localhost:5432/mempalace_test
+        run: python -m pytest tests/test_backends_postgres.py -v
