-
Notifications
You must be signed in to change notification settings - Fork 1
/
db_init.sh
11 lines (9 loc) · 640 Bytes
/
db_init.sh
1
2
3
4
5
6
7
8
9
10
11
#/bin/bash
#sh db_init.sh my_database schema_my_database_adm
docker compose exec postgres psql -c "CREATE USER $1 WITH ENCRYPTED PASSWORD '$1';"
docker compose exec postgres psql -c "CREATE DATABASE $1 WITH OWNER $1;"
docker compose exec postgres psql -c "GRANT ALL PRIVILEGES ON DATABASE $1 TO $1;"
docker compose exec postgres psql -d $1 -c "ALTER SCHEMA public OWNER TO $1;"
docker compose exec postgres psql -d $1 -c "ALTER SCHEMA public RENAME TO $2"
docker compose exec postgres psql -d $1 -c "ALTER USER $1 SET search_path TO $2;"
docker compose exec postgres psql -d $1 -c "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA $2 TO $1;"