fix: CI E2E tests failing — Postgres role 'root' does not exist

[realityinspector]

Problem

The GitHub Actions E2E test suite is failing because the Postgres service container doesn't have the correct user configured. The test tries to connect as root but the default Postgres image only creates a postgres user.

Error from CI logs:

FATAL: role "root" does not exist

Run: https://github.com/timepointai/timepoint-flash/actions/runs/22933771180

Fix

In the GitHub Actions workflow file (likely .github/workflows/tests.yml), add POSTGRES_USER to the Postgres service container environment, or update the test database URL to use the postgres user:

services:
  postgres:
    image: postgres:15
    env:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: flash_test

Make sure the DATABASE_URL env var in the test job matches.

Also

The CI is warning about Node.js 20 deprecation for actions/checkout@v4, actions/setup-python@v5, actions/upload-artifact@v4. These will be forced to Node.js 24 starting June 2, 2026. Not urgent but worth updating.