diff --git a/docker/docker-compose.yml b/docker/docker-compose.yml --- a/docker/docker-compose.yml +++ b/docker/docker-compose.yml @@ -136,6 +136,8 @@ env_file: - ./env/common_python.env - ./env/scheduler-db.env + volumes: + - "./services/dbs/init-guest-user-db.sh:/docker-entrypoint-initdb.d/init-user-db.sh:ro" swh-scheduler: image: swh/stack @@ -239,6 +241,8 @@ image: postgres:12 env_file: - ./env/storage-db.env + volumes: + - "./services/dbs/init-guest-user-db.sh:/docker-entrypoint-initdb.d/init-user-db.sh:ro" swh-storage: image: swh/stack @@ -282,6 +286,8 @@ image: postgres:12 env_file: - ./env/indexers-db.env + volumes: + - "./services/dbs/init-guest-user-db.sh:/docker-entrypoint-initdb.d/init-user-db.sh:ro" swh-idx-storage: image: swh/stack @@ -306,6 +312,8 @@ image: postgres:12 env_file: - ./env/01-web-db.env + volumes: + - "./services/dbs/init-guest-user-db.sh:/docker-entrypoint-initdb.d/init-user-db.sh:ro" swh-web: build: ./ @@ -355,6 +363,8 @@ image: postgres:12 env_file: - ./env/deposit-db.env + volumes: + - "./services/dbs/init-guest-user-db.sh:/docker-entrypoint-initdb.d/init-user-db.sh:ro" swh-deposit: image: swh/stack @@ -381,6 +391,8 @@ image: postgres:12 env_file: - ./env/vault-db.env + volumes: + - "./services/dbs/init-guest-user-db.sh:/docker-entrypoint-initdb.d/init-user-db.sh:ro" swh-vault: image: swh/stack diff --git a/docker/services/dbs/init-guest-user-db.sh b/docker/services/dbs/init-guest-user-db.sh new file mode 100644 --- /dev/null +++ b/docker/services/dbs/init-guest-user-db.sh @@ -0,0 +1,7 @@ +#!/usr/bin/env bash + +set -e + +psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <