gitza-mcp/deploy/init-db.sh

10 lines
425 B
Bash

#!/bin/sh
set -eu
# psql reads the password from the environment; it never appears in command arguments.
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<'SQL'
\getenv app_password MCP_DB_PASSWORD
CREATE ROLE mcp LOGIN PASSWORD :'app_password' NOSUPERUSER NOCREATEDB NOCREATEROLE;
ALTER DATABASE mcp OWNER TO mcp;
ALTER SCHEMA public OWNER TO mcp;
REVOKE CREATE ON SCHEMA public FROM PUBLIC;
SQL