Wrong schema used in postgres

[bronweg]

When PostgreSQL DB chosen, public schema is used instead of ambari schema.
This is not a problem until you want to upgrade the cluster.

When I tried to upgrade my cluster (installed with that ansible playbook), I fault on ambari schema doesn't exist. To avoid this, I ran ambari-server setup with --postgresschema=public, and manually changed that schema owner to ambari user. Only after that I successfully upgraded my cluster.

According to that documents: 2.6, 2.7, ambari schema should be created during the installation and ambari user should be the owner of that schema, but that doesn't happen here.

[alexandruanghel]

Wow, great find @bronweg this is definitely a bug in the playbooks.

I'll work on a fix, thanks!

[lhoss]

When I tried to upgrade my cluster (installed with that ansible playbook), I fault on ambari schema doesn't exist.

👍 I had ran into exact same issue
and I agree it would be nice to fix this the role (if I had some spare time!)

I ran ambari-server setup with --postgresschema=public

Your fix (1.step) was even more elegant. My fix was to change the related schema parameter in /etc/ambari-server/conf/ambari.properties