Set database schema ownership correctly

getodk / aggregate

ODK Aggregate is a Java server that stores, analyzes, and presents survey data collected using ODK Collect. Contribute and make the world a better place! ✨🗄✨

https://docs.opendatakit.org/aggregate-intro/

Other

74 stars 228 forks source link

Set database schema ownership correctly #410

Closed ggalmazor closed 5 years ago

ggalmazor commented 5 years ago

We should ensure the database schema aggregate is owned by the aggregate user.

ALTER SCHEMA aggregate OWNER TO aggregate;

This should be changed in:

Documentation & set up instructions
Cloud-Config stacks
Docker & Docker compose db init scripts
Packer VM build
Development db (Docker) db init scripts

Changing this will ensure db backup and restore operations go smoother.