synchrod-pg

Overview ¶

synchrod-pg is the sync HTTP server backed by the synchro_pg PostgreSQL extension. It is a thin adapter: JWT auth, version check, and passthrough to SELECT synchro.synchro_*() functions. No Go-side sync engine, no WAL consumer, no migrations. The extension handles everything.

Required: PostgreSQL with synchro_pg extension installed.

Environment variables:

DATABASE_URL         PostgreSQL connection string (required)
WORKER_DATABASE_URL  Worker connection string (required for projection-bootstrap)
LISTEN_ADDR          HTTP listen address (default: :8080)
JWT_SECRET           HS256 shared secret (mutually exclusive with JWKS_URL)
JWKS_URL             RS256/ES256 JWKS endpoint (mutually exclusive with JWT_SECRET)
JWT_USER_CLAIM       JWT claim for user ID (default: sub)
MIN_CLIENT_VERSION   Minimum client semver (optional)
LOG_LEVEL            Log level: debug, info, warn, error (default: info)