docker/create-gerrit-dbs.sh

USERNAME="gerrit"
USERPASS="gerrit"

# create user and modify password
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
  CREATE USER "$USERNAME";
  ALTER USER "$USERNAME" WITH PASSWORD '$USERPASS';
EOSQL

# create caches DB
DBNAME="gerrit_caches"
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
  CREATE DATABASE "$DBNAME" ENCODING UTF8;
  GRANT ALL PRIVILEGES ON DATABASE "$DBNAME" TO "$USERNAME";
EOSQL

# create review DB
DBNAME="gerrit_review"
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
  CREATE DATABASE "$DBNAME" ENCODING UTF8;
  GRANT ALL PRIVILEGES ON DATABASE "$DBNAME" TO "$USERNAME";
EOSQL