Local development
Running the whole stack from one command.
Everything runs from one command:
pnpm install
pnpm devPostgreSQL in a container
pnpm dev:db starts the postgres service of docker-compose.dev.yml. The data lives in a named volume, so it survives docker compose down.
A system-wide PostgreSQL already listening on 5432 wins over the container for connections to 127.0.0.1, and the only symptom is role "payload" does not exist. Stop it, or move the mapping to 5433 and follow through in DATABASE_URI.
Schema
The Postgres adapter pushes the schema on boot in development, so there is nothing to migrate locally. A shared environment needs real migrations.