Operations

PostgreSQL (control plane)

Migrations, bootstrap, and schema central for the app database.

Standard migrate

npx prisma migrate deploy

Run prisma/postgres-grants.sql as superuser if the app role cannot CREATE on public.

Restricted public schema

When prisma migrate deploy fails with migration persistence errors:

# Use schema=central in DATABASE_URL when supported
npm run db:bootstrap
npm run db:apply-patches
npm run db:verify

Verify

npm run db:verify

Checks connectivity and that the user table exists in schema central (or public).

VPS operations

SSH user, deploy paths, git, TLS, and failure modes on target servers.

Docker install profile

Bundled Postgres, Redis, and optional app stack for control plane installs.

On this page

Standard migrate Restricted public schema Verify