I wondered why I named my databases b_discourse and c_discourse. Now I know why. 
## Plugins go here
## see https://meta.discourse.org/t/19157 for details
hooks:
after_postgres:
- exec: sudo -u postgres createdb b_discourse || exit 0
- exec:
stdin: |
grant all privileges on database b_discourse to discourse;
cmd: sudo -u postgres psql b_discourse
raise_on_fail: false
- exec: sudo -u postgres createdb c_discourse || exit 0
- exec:
stdin: |
grant all privileges on database c_discourse to discourse;
cmd: sudo -u postgres psql c_discourse
raise_on_fail: false
- exec: /bin/bash -c 'sudo -u postgres psql b_discourse <<< "alter schema public owner to discourse;"'
- exec: /bin/bash -c 'sudo -u postgres psql b_discourse <<< "create extension if not exists hstore;"'
- exec: /bin/bash -c 'sudo -u postgres psql b_discourse <<< "create extension if not exists pg_trgm;"'
I don’t fully understand how privileges are granted so I wondered about these. (screen shot from above for two problematic databases):
