10 lines
425 B
Bash
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
|