Support automatic user/database/shema creation for remote db (aws/gcp)

Description

As a work around, the following SQL should be executed manually:

1 2 3 4 5 6 7 8 9 10 11 psql -h YOUR_HOST -d template1 -c "CREATE USER 'aerobase_server'" psql -h YOUR_HOST -d template1 -c "CREATE USER 'keycloak_server'" psql -h YOUR_HOST -U postgres -d template1 -c "GRANT aerobase_server to postgresql"; psql -h YOUR_HOST -U postgres -d template1 -c "GRANT keycloak_server to postgresql"; createdb -h YOUR_HOST -O keycloak_server unifiedpush_server -U postgres; createdb -h YOUR_HOST -O keycloak_server keycloak_server -U postgres; cp /var/opt/unifiedpush/unifiedpush-server/etc/db.properties /tmp/ /opt/unifiedpush/embedded/apps/unifiedpush-server/initdb/bin/init-unifiedpush-db.sh --database=unifiedpush_server --config-path=/tmp/

Status

Assignee

Unassigned

Reporter

Yaniv Marom NAchumi

Labels

None

Fix versions

Priority

Medium