Created attachment 1431438 [details]
Description of problem:
It shows errata while upgrading DB from bz4 to bz5, please check the attchment
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.Import a BZ4 db into BZ5 server database
2.Run the ansible:
ansible-playbook -v playbooks/deploy.yml --limit=qe-pek2 --extra-vars "upgrade_from_bz4=True"
": ERROR: must be owner of database bugs" Configuring the owner of the database is not, and cannot be, part of the playbook.
After I assign the superuser role to user apache and bugs in the DB side, it still shows the same error. Could you tell me which user should be assigned what permission?
1: There should not be an apache user in the DB.
2: The bugs user should not be a super user
3: ALTER DATABASE bugs OWNER TO bugs;
4: You can skip step 3 if you use --username=bugs when using pg_restore.